errorw with imported CSV file

[Guest]

I am importing a CSV file into an Access database with VB code. The second
field in Access has been designated as a "text" field. In the CSV file, the
second field contains letters and numbers.

After the import, when you look at the table, the numbers appear but the
letters are missing.

This same thing also happened with the eighth field. A "new" table is
created for the import errors in both fields. The error is "Type Conversion
Failure". I did notice that the first line of data contains numbers in these
fields.

Any suggestions on how to correct this issue would be greatly appreciated.

 

[Guest]

It appears you are creating a new table when you do the import. If you are,
then I would suggest you change your import to import into an existing table.
Set the field types in the Access table the way you want them. Also, it
would be a good idea to create an import spec for your csv file and use that
for your import.

This is a common problem, because without any data type specifications to go
by, Access is trying to figure out the proper data type. When it sees the
first row has numbers only, it makes the data type a number.

 

[cedric_san]

did you sort this out?

JT,

Did you find a solution to that?
I have the same issue and even with a table already existing, with the text field where I want it to be it still returns an error for the records where the data is text and non numeric like.