Import Excel File into Access 2003 database and getting errors

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear All,

I created a database in Access 2000 and was able to import data from an
excel file into an existing table without a problem. We recently switched
over to Access 2003 and I tried to import an excel file which is set up
exactly like the previous excel file. I received an error message. So I
imported the file into a new table and copied it into the original table and
it worked. What could be the reasons for the errors in the import of the
excel file into the existing table? Thanks.

Neal
 
Dear All,

I created a database in Access 2000 and was able to import data from
an excel file into an existing table without a problem. We recently
switched over to Access 2003 and I tried to import an excel file which
is set up exactly like the previous excel file. I received an error
message. So I imported the file into a new table and copied it into
the original table and it worked. What could be the reasons for the
errors in the import of the excel file into the existing table?
Thanks.

Neal
Click to expand...

Do the formats of data in Excel and Access match?

I do not import but link to Excel and CSV files. Similar problems occur as
Access does not always correctly recognize the format of a field in the
source.
This then has to be modified by hand in the definition of the link.

Another source for trouble with reading an Excel sheet is the formatting of
a column in the sheet.
If by any chance the cell formatting in a column changes down the column I
have had problems in getting all the data available in Access (or was it in
Crystal Reports?).
Such formatting differences are sometimes difficult to trace when numbers
are both entered as numbers and in other cells as right aligned text.
You will then get an error message indicating that the format of the data
does not match the format of the field it is used in.
 
Ken,

The error only says that there were errors importing the file and that the
import was not successful. It does not specifiy why.

Neal
 
Thanks for the ideas. The crazy thing is the excel file is coming from
another Access database as a query so I thought that the data would be
consistant.

Neal
 
It may be that ACCESS 2003 is "assigning" a different data type to some of
the EXCEL columns than ACCESS 2000 does. When importing EXCEL data, it's
almost always best to import to a new table, then use an append query to
copy the data to the permanent table -- that gives you more control over
data formatting, etc.
 
Back
Top