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...
Joe Fallon - 04 Sep 2004 03:30 GMT
Not sure...
Did you check the table structure?
Are zero length fields allowed?

Signature
Joe Fallon
Access MVP
> I'm importing data from Excel to an existing Access
> table. Some of the fields in the Excel spreadsheet are
[quoted text clipped - 3 lines]
> field caused a Type Conversion Failure error. Why, and
> how do I avoid this? Thanks...