Importing Excel '03 files into Access '00

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

Hello,

I have created a simple Access dbase and need to import several excel files
into one table. My imports are done over time rather than one time due to
collecting data on the Excel front. I was able to import the 1st file but
there after I get an error message "An error occured trying to import (file
name & location), the file was not imported. There has to be a way to bring
spreadsheets into 1 Access table, I just can't figure it out. Can someone
please advise? I'm a very basic Access user and don't understand most of the
technichal language that's been posted. So if someone could explain it in
elementary terms that would be very helpful!

Thanks! Ann
 
What was the reason it would not import the file?
Does the table you are importing into have a primary key field?
Are you trying to import data from the file into the primary key field?

This is a very common problem. Primary key fields cannot have any duplicate
values. If you are trying to import a value that already exists in that
field in the table, it will fail.

If you can provide a bit more detail, I think we can make it work.
 
It does not give me a reason, ony the error message "An error occured trying
to import (states the file name & location), the file was not imported." I do
not have a primary key field which I feel like I should.

Thanks Dave for your willingness to help :)
Ann
 
Go to the tables tab in your database window. You will find one or more
files with something like $_ImportErrors in the name. That will give you
some additional information. If you don't have a primary key in the table,
then it may be incompatible data types.
Does the table already exist or is the import trying t create the table?
 
Does the file you are trying to import now have the same columns as the one
you originally imported?

Just as an experiment, try importing this new file into a new table that
doesn't exist. Let the import create the table.
 
I exported the old table & overrode the old with a new table that included an
auto number. That combined with having the exact field names from both the
excel file & the new table which has the auto numbers appears to have done
the trick. I was able to import an excel file into the new existing table. So
keep your fingers crossed that it will work again.

Many thanks for your help!

Ann
 
Back
Top