Incremental Imports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 am trying to import 2 different excel worksheet into a access table and
want to keep addign to that particular table.Is that possible
Click to expand...

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]
 
you can keep adding data in Access
Unless your primary key is an autonumber field, otherwise the unique index
would stop duplicate information.
 
You must log in or register to reply here.

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

Easy Steps to Import PST Files to Office 365 0
import multiple Excel worksheet into a main Access table 1
How can I import an unstandard Excel worksheet into Access 2007? 3
Import data from Access to Excel containing VB code 3
How to export table from outlook into ms access table? 0
Importing Text Files Into Access 1
Browse button for access form 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top