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.

 

[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.