I'm having a issue with some source data that I import from a system. the system creates its exports as an .xls file and one of the fields has text in it like follows:
1.1
1.1.2
1.2
1.2.1
1.2.2
When a user opens the Excel file prior to uploading (I have asked them not to!!), Excel converts some of the rows to numbers and I get a data type error on the load because I'm loading it into a text field in the db.
Is there a way to force Access to read it as text no matter what Excel has done to the data.