Hi Guys,
Sorry for posting also here and to excell but it's related.
When I try to import an excell sheet that has dates in the form
19/9/03 to access, I get type conversion failure.
If the date is 19/09/03 then it works fine.
I have also one other column with numbers. If there is space between them it gives me again a type conversion failure, even though I format the cell to text.
For instance: 345 678 ->error
but 345678 works ok.
So I need a function to remove internal spaces from this column.
I also need a function to put 0 before the month unless someone has a better idea on how to make it work.
Thanks in advance,
George
Sorry for posting also here and to excell but it's related.
When I try to import an excell sheet that has dates in the form
19/9/03 to access, I get type conversion failure.
If the date is 19/09/03 then it works fine.
I have also one other column with numbers. If there is space between them it gives me again a type conversion failure, even though I format the cell to text.
For instance: 345 678 ->error
but 345678 works ok.
So I need a function to remove internal spaces from this column.
I also need a function to put 0 before the month unless someone has a better idea on how to make it work.
Thanks in advance,
George