Importing Excel Data into MS Access Table

[Love Buzz]

Hi All.

I go to 'Get External Data' and bring in an Excel file into a new MS Access
table. I go through the Wizard and everything looks fine. However, when I
select 'Finish', I get the message 'An error occured trying to import file
'file name' the file was not imported'.

I get that message when trying to import into an existing table and a new
table. The column headers, etc. match exactly, but there is something
obviously preventing me from successful importing.

Any ideas? Thanks for your help.

 

[Chris O'C via AccessMonster.com]

Convert the Excel file to csv format so you can use the import text wizard.
When that wizard fails, it produces an error table that lists each row that
failed and the reason.

Chris
Microsoft MVP

 

[Pete D.]

I see this error for couple of reasons. Column headers are not same (hidden
info in excel that access sees such as returns or ' to create text cell) or
reserved words in Access. Also when access guesses at the field/cell format
and it isn't correct. Usually seeding a few rows in Excel (enter perfect
data for access field format) cures it and provides a hint as to what is
going on.