Incremental Imports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sim - 26 Feb 2007 19:38 GMT

I am trying to import 2 different excel worksheet into a access table and
want to keep addign to that particular table.Is that possible

Reply to this Message

John W. Vinson - 26 Feb 2007 20:16 GMT

>I am trying to import 2 different excel worksheet into a access table and
>want to keep addign to that particular table.Is that possible

I'd suggest using File... Get External Data... Link to the
spreadsheet, and run Append queries to move the data into your table.

Once you have done so, the data is completely independent of Excel;
you can keep adding data in Access, edit it, delete records, etc. as
you wish. Changes made to the spreadsheet will NOT be reflected in
Access, though.

John W. Vinson [MVP]

Reply to this Message

KARL DEWEY - 26 Feb 2007 21:03 GMT

>>you can keep adding data in Access

Unless your primary key is an autonumber field, otherwise the unique index
would stop duplicate information.

Signature

KARL DEWEY
Build a little - Test a little

> >I am trying to import 2 different excel worksheet into a access table and
> >want to keep addign to that particular table.Is that possible
[quoted text clipped - 8 lines]
>
> John W. Vinson [MVP]

Reply to this Message