Error report from data import

[Robin Chapple]

I have imported data from a CSV file and received an error message
that Field 11 in line 1082 had a "type conversion" error.

I accept all the default settings in the wizard so Access provides key
IDs.

Is line 1082 now ID 1082?

Thanks,

Robin Chapple

 

[Dennis Schmidt]

Hi Robin,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

If you were importing the data into a new table and the autonumber field
was starting at 1, the error table would be referring to record #1082. You
should be able to identify the record by looking at the field it mentions.
In your new table, that field for that record should be blank.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support

 

[Robin Chapple]

Greetings Dennis,

Thanks for that information. You rightly confirmed that the field was
empty and it allowed my to identify the entry from the surname field
and then find the surname in the CSV file at line 6887 to correct the
error.

I have also been able to correct the source.

Your help is appreciated.

Robin Chapple