using table stucture and importing data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Linda - 31 Jan 2008 22:01 GMT

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

Reply to this Message

Jeff Boyce - 31 Jan 2008 23:13 GMT

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

>I have been having alot of problems in importing data from an excel file
>into
[quoted text clipped - 10 lines]
>
> Linda

Reply to this Message