Import errors when importing txt files

[lenk73]

I work off a server. My coworker can do this and receives no errors, when I do the same thing, I'm getting errors: I run a txt file, hit external data, text file, append a file to an already created table, go through prompts (same prompts coworker has) and hit finish. I receive this error:



finished importing file xxxx to table xxx. Not all of your data was successfully imported. Error descriptions with associated row numbers of bad records can be found in the Microsoft Access table xxx, xxx.

When I open the "bad" table file, the errors say type conversion error. We run the original txt from an exported sql query. Should all be the same.

[ItsMe]

Sometimes, when importing Text files, I will use a temp table where each field is of type text. Afterwards, I will do data validation via VBA and append the validated data to the permanent table. Another approach is to automate the text file and do validation prior to importing.

[ranman256]

The data layout is not correct. Access is interpreting Text as numeric so you get the error.
Either your schema is wrong, or the text is. Rebuild the schema (data layout)

[lenk73]

that would make sense if my coworker was getting the same error, but when he imports, there are no issues. i'm thinking it might be a setting in my access somewhere.

[ItsMe]

... i'm thinking it might be a setting in my access somewhere.

.
.
I am not.