Problem with importing excell file to access

[geo__]

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

 

[Mile-O]

Please don't double post. This has already been answered here.