View Full Version : error messages after import


EveNg
02-27-2002, 02:57 PM
Can anyone pls help me understand the below error messages?

------
!Import Spreadsheet Wizard

Finished Importing File 'C:\Documents and Settings\evng\MyDocuments\106000.xls'to table 'A-D'. Not all of your data was successfully imported. Error description with associated row numbers of bad records can be found in the Microsoft Access table "A-D'$_ImportErrors3'.
------

after the message i have this table name: 'A-D'$_ImportErrors shown on my window.

when i click on the 'A-D'$_ImportErrors table, it shows

Error Field Row
Type Conversion Failure F10 15
Type Conversion Failure F10 23


This happened after i imported one of the Excel Sheet to Access table. the source of the Excel file was imported from a text file.

ya, it sounds real complicated, but can someone pls tell me what's going with that? Thanks a lot!

eve

Alexandre
02-27-2002, 03:33 PM
Type Conversion Failure means that access found in the file to import a value that did not fit the data type for this field.
Unless you specify data types manually, access tries to guess the data type for each field on the base of the first(s?) values in the file to import.
If later on a value in found that does not match the field type, ans error is logged to the Error table.
F10 15 are the coordiantes of the value that caused the erro in your imported file (Field F10, row 15).

Use the key word import in access help and look for importation errors table for more details.

Alex