using table stucture and importing data

  • Thread starter Thread starter Linda
  • Start date Start date
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
 
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
 
Back
Top