Import Problem

[Guest]

I have an excel spreadsheet that I want to import into an access table. I go
to Get External Data and choose the file and go through the dialog boxes,
when I click Finish, I get the following error message: "An error occurred
while trying to import file …. The file was not imported". It doesn't offer
me a help menu to suggest why the file didn't import.

Could anyone tell me why this is happening or what I can try to fix this
problem. The field names in the header row corresponds with the access table.
It should be a fairly straightforward import.

Thanks in advance for any help. I am using Access 2003.

Best regards,

Dee

 

[Guest]

There is a ton of different things that could be causing this - And it
depends what you want to do with the data as to how to import it.

Some recommendations:
1st if you just want whats on the spreadsheet into access once, copy all the
data and paste as VALUES to a new spreadsheet. Save that new file as a .CSV
and import that - you'll have less issues that way.

2nd if you want the spreadsheet to be live so that when the sheet is updated
the info in access is updated, you'll want to link the data. Some of the
stuff I've experianced with what you described is you're sheet has something
in the 256th column and Access is trying to import a bunch of blank "columns"
as fields. Hit ctrl-end and see where it takes you, if you end up off in
never never land, copy the range of data you're working with to a new
spreadsheet save it, then overwrite the one that had bogus data.

-steve

 

[Ange]

Dee,
Check to see if the Excel file you are trying to import is open. I
received the same error just the other day and it took me about a half
an hour to figure out that the spreadsheet I was trying to import was
already open. I closed the spreadsheet and then had no problems with
the import. (Just a suggestion but as the last guy said - It could be
anything.)

Thanks,
Ange