type conversion failure error

[gailygirl]

I am trying to import a spreadsheet from Microsoft Excel. Some of the fields
are blank. The import itself works perfectly except I get import errors
(type conversion failure) for the blank fields. Any suggestions?

 

[rwr]

I am trying to import a spreadsheet from Microsoft Excel. Some of the fields
are blank. The import itself works perfectly except I get import errors
(type conversion failure) for the blank fields. Any suggestions?

You may want to import into a temp table and define all of the fields
text or strings. Then with code or an update query, append the data to
your table.

Ron