Import from Excel error

eclipse33

New member
Local time
Today, 04:57
Joined
May 2, 2006
Messages
3
Hi All
I'm trying import an excel spreadsheet into an exisiting table. But there are some conversion errors in some records. But there is no conversion error table or log for me to trace. Anyone knows how can I find the records with error in order to fix them? Thanks in advance!
 
Access determines the data type by something like the first 10 columns. If you have mixed data but the first 10 or so are numbers, then access thinks the column is number and you will have a conversion error. The way around this is to put a ' in the first column or two and it will tell access this is a character field. I do not know if that is your problem or not but am offering this as a potential fix.
 
Actually I'm importing the excel into an EXISTING table, which the data type of the columns have been defined. But when I import the data from excel, access complaint that some records could not be imported because of of the data type mismatch or data length too long. But it didn't suggest which row has problem. So I have to scan through the excel and find the fields with error.

Is there any way I can trace the row number with import error so that I can fix them in excel?
 
It doesn't matter if it is an EXISTING table. Access will perceive the data as I described no matter how you defined the table.
 
I seem to recall when I have had problems with imports, access has created an error table. Have a look to see if you have such a table.
 

Users who are viewing this thread

Back
Top Bottom