Importing data from Excel 2002 file

M

Michelle

I have a database with a table set up and am trying to
import the data from an Excel 2002 spreadsheet. The
fields are labeled correctly and the formats are set.
When I try to import the data, the message I get is "An
error occurred trying to import file.....The file was not
imported." I can import the data into a new table and it
works fine but I already have the other table set up how I
want it to be. I have double-checked everything I can
think of -- anyone have any ideas? Thanks.
 
J

Joe Fallon

Not sure but I always import to a new table anyway.
Then I write queries to move the data from the temp table to the real table.
(The queries can format data and massage the raw data so it "fits" the real
table.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import data from excel 2002 to Acess 2002 2
importing from Excel 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
using table stucture and importing data 1
Error Message - Importing Excel to Access 2003 2
Importing via TransferSpreadsheet, receiving "type conversion fail 1
Error importing to Access - file was not imported 1
Importing Excel Data into MS Access Table 1

Top