Importing via TransferSpreadsheet, receiving "type conversion fail



I have a table existing in Access, and a matching spreadsheet tab in excel.
Field formats in both files are identical (set to text). Using a macro and
the TransferSpreadsheet function, I have successfully imported the majority
of my data. However, columns in the excel file where there is alpha-numeric
data in columns mixed with only numeric data, or if most cells are empty and
a few in a column have text, they are not being imported into my access
table. They are instead put into a $_ImportErrors table.

I realize the macro is not following the format outlined by the excel file
or the access table when performing the import. Is there any way to
eliminate this type of errors? Or to indicate what format should be followed
in the import for the specific columns?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question