type conversion failure error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
gailygirl said:
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?
Click to expand...

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
 
Back
Top