Importing Zero-Length Text String

  • Thread starter Thread starter Mark H.
  • Start date Start date
M

Mark H.

I'm importing data from Excel to an existing Access
table. Some of the fields in the Excel spreadsheet are
zero-length text strings (=""), and these fields are
formatted as text in my Access table. But when I try to
import, Access creates an ImportErrors table and says that
field caused a Type Conversion Failure error. Why, and
how do I avoid this? Thanks...
 
Not sure...
Did you check the table structure?
Are zero length fields allowed?
 
You must log in or register to reply here.

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

Similar Threads

Import CSV Type Conversion Failure 3
CSV import error only with code 1
How do I keep leading zeros and remove the decimal point when expo 2
Type Conversion Failure importing number as text 1
Importing Text Files Into Access 1
why "Type Conversion Failure" import EXCEL into ACESS TEXT field 1
Import Excel 2002 to Access 2002 1
Importing via TransferSpreadsheet, receiving "type conversion fail 1

Back
Top