Import data from excel 2002 to Acess 2002

  • Thread starter Thread starter sheena
  • Start date Start date
S

sheena

I have set up a table in access, I have tested all the fields and now I am
ready to import some data from excel.
The problem is I keep gettin an error message saying "an error occured
trying to import file. the file was not imported"
The data in excel has the same headings as the headings in Access.
I thought the importing would be a fairly simple task.
If you require any further information please let me know, I have tried to
explain as best as I can.

Thank you
 
sheena said:
I have set up a table in access, I have tested all the fields and now I am
ready to import some data from excel.
The problem is I keep gettin an error message saying "an error occured
trying to import file. the file was not imported"
The data in excel has the same headings as the headings in Access.
I thought the importing would be a fairly simple task.
If you require any further information please let me know, I have tried to
explain as best as I can.

Thank you
Click to expand...
 
Sheena,

The problem lies somewhere in that particular worksheet.
There can be problems with numbers saved as text.
There can be problems with date and time formats - that access has trouble
importing.
Check the column headings spaces or strange characters.
There can be problems with formats on the worksheet.
There can be problems with empty cells in Excel with time formats.
There can be problems with the way the worksheet is set up.
To check this, in excel, select the worksheet by clicking on the empty
square at the intersection of the top of the row numbers and the left most
of the column headings.
Go Ctl + End and see where the worksheet ends. By default Access will import
all the cells that you can see selected - there may be some problem with
empty cells with formats that are a problem for Access to import or that
don't
match the fields in your import table.

If none of the above work, import it into a new table, check each field to
see if access had a problem with formats.
You may find that if you create a half-way import table with all fields as
text type, you can import into this half-way table.
If this works, then set up append queries to move the data into the fields
in the real table.
You may need to convert some fields from text type to the appropriate type -
number or date fields.
A trouble shooting approach is to do the import one column/field at a time.
Import only the 1st column from the worksheet. If that imports OK, try the
next column. You can work your way through like this and discover which
columns are a problem for access to import.

Check if the worksheet is protected, remove protection and try again.

Jeanette Cunningham
 
Back
Top