Import udated data tables

  • Thread starter Thread starter Russell G. Kimball
  • Start date Start date
R

Russell G. Kimball

Can any one help me with a macro that will import updated data tables into
current tables of another database.

Thanks
Russ
 
Russ,

Can't really make any specific comments without more information. But I
would imagine the general concept here is a TransferDatabase action in
your macro, followed possibly by an OpenQuery action to run an Append Query.
 
link the update tables into that other database through Get External data
 
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

VBA - retrieve data on last create named range from previous inserted named range 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Compact & Repair, Open table, close table, then run macro 3
Import Spreadsheet Problem 3
Run a macro and pause before running second macro 1
How to export table from outlook into ms access table? 0
Export table to txt file with a variable filename 0
Import a table creates a new table 2

Back
Top