importing data from excel to access 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

msdobe1 - 29 May 2008 19:46 GMT

I've got some data I'd like to import (never imported data before in access).
The field names are the same - first name, last name email, etc. But when I
go to import it into a pre-existing table I get an error. All it says is 'An
error occurred trying to import file .... The file was not imported.

Can someone help, please.

Thanks!
Jenny

Reply to this Message

banem2@gmail.com - 30 May 2008 07:31 GMT

> I've got some data I'd like to import (never imported data before in access).
> The field names are the same - first name, last name email, etc. But when I
[quoted text clipped - 5 lines]
> Thanks!
> Jenny

Try importing into new table and then copy data to your table. Usually
there are empty cells in your Excel file, while Access (sometimes by
user design of a table) does not allow empty fields to be imported.

Regards,
Branislav Mihaljev
Microsoft Access MVP

Reply to this Message