import tables from one database into another using VBA

  • Thread starter Thread starter Mark Kubicki
  • Start date Start date
M

Mark Kubicki

I need to write some code to import tables from an external Access database
(for use in update queries) into the current database...
It ought to be simple, but my syntax seems to be completely in the wrong
ballpark, and any suggestions would help...

What would the format for the code ?

thanks in advance,
mark
 
Do the external database file and its tables always have the same name? If
so, I suggest linking to those tables instead of importing them. You could
run update or append queries from them.
 
the external files will be deleted; only specific tables within those files
have information that needs to be included in the new files.
 
Back
Top