Another table gets created when I import data from excel

[BizBoy]

Hi,
I am importing an excel file in MS Access.
This excel file has only one worksheet i.e. Sheet1.
Whenever I import this file in access, another table is created with name as Sheet1$ImportErrors.

When I double click on this table. I can see 3 columns.
Error, Field, Row
Error field has only one value ‘Type Conversion Failure’.
Field (2^nd column) has value has Extension.
Row has numbers.

Can anyone please help me understand what is this.
Should I ignore this or does this table has importance.
Usually I delete this table.

 

[Joe4]

This table is only created when you have import errors. You should check it to make sure that all the data you need was imported successfully.
Sometimes, there are some blank or formatted rows at the bottom of your Excel file that its tries to import, but fails. So if you see blank/empty records in this table, that is probably what that is.

You can prevent that by deleting the blank rows at the bottom of your Excel file (if that is what it is). Or just continue to check this table and delete it each time.

 

[xenou]

Generally that means some of the data was not imported. In this case it would mean that the column titled "extension" didn't import data from those rows (if you look in the table those values are probably blank).

For Excel to Access the most common problem is that the column in Excel has some values that look like numbers and others that look like text in the same column. Access has problems with data like that - in Access, numeric fields should have only numbers. (if the data has some text and some numbers then Access may try to import as numeric data, then fail on the values that are not numbers).

 

[BizBoy]

Hi Joe,

Thanks a lot for the help. Have a nice day ahead.

 

[BizBoy]

Hi xenou,

In Extension column (4 digit numbers) , there are few blank records. Also, some of these records were reflecting as text, converted it to number by doing Alt + D + E + D + F.
I think issues might be due to blank records.

Thanks a lot for the help. Have a nice day ahead.