Bring in numeric text field to access from excel

[Sck]

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.

[ConneXionLost]

When Access imports a block of data from Excel, it usually looks at the first row to determine what the data types should be for each column. So, in your Excel workbook, try placing a "dummy" row at the top of your import sheet, with a text item in the position to be read for the appropriate column. Once the import is complete, delete the dummy row from your Access table.