using table stucture and importing data

L

Linda

I have been having alot of problems in importing data from an excel file into
a current table. I want to maintain the table structure, with field
descriptions, which is why using the "linked tables" option doesn't work for
me - it doesn't use descriptions.
The issues I am having importing data into a table are the usual - an error
occurred when trying to import file XYZ. File was not imported.
Is there any way to link the tables and maintain structure?

Thanks,

Linda
 
J

Jeff Boyce

Linda

Create a link to the (raw) Excel file. Excel data is rarely well-normalized
(nature of the beast and all ...)

Create a well-normalized Access data structure (could be MORE than one
table).

Create queries that "parse" data from the linked Excel source and
append/update data in the Access table(s).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Problem importing data into linked table 2
Problems Importing Excel Files to an Existing Table 1
Importing data from DB2 1
Importing XML Data in Access 2003 1
Importing Excel Data into MS Access Table 1
Importing into a table 1
Importing text into number field- Error 4
Importing Data 1

Top