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
"Dee" wrote:
[Quoted Text] > 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
|