Hi! I'm trying to import an Excel sheet file into an Access table using Docmd.TransferSpreadsheet method. The big issue is that I always receive an error when importing and a "TableName$_ImportErrors" table is created. This table contains 3 fields (Error, Field, Row). In error field I have a "Type Conversion Failure". It seems that Access reads the content of the first cell from a column of the Excel table and if a numeric value is found , then he can't handle any value, on that column below, which is not a number.
In the example below,importing process will work for column 1&3, but will fail on column2, at X67. Thanks for any solution/workaround.


220 63 ZT
x209 67 ZF
134 X67 ZM

Have you tried creating a Link to the Excel File, and then looking to see what Access does to field definition types, and then dumping into another 'internal' Access Table?



Database Agreements

Hmm.
Now that I look at this again, I think that Access is putting a field in the Excel File, which is expected to be a number for the first column, and trying to put it into a Number column.]
However, when there's an alpha char, it dies, rightly so, since it wants you to be specific about what you want to do with the data.
Hence, define the column as a text field in the Access table you are dumping data too.



Database Agreements