G
Guest
I have an excel file that has a field/column of data like 1.2.3. When I try
to import this excel file in access it reads the text 1.2.3 as a number
instead of text. In the excel file it is formatted as txt but access
switches it to a number format. And since it is not a correct number
format I get errors. This problem occurs if I link the file or import it in.
What can I do to fix this.
Sarah
to import this excel file in access it reads the text 1.2.3 as a number
instead of text. In the excel file it is formatted as txt but access
switches it to a number format. And since it is not a correct number
format I get errors. This problem occurs if I link the file or import it in.
What can I do to fix this.
Sarah