import tables from one database into another using VBA

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
 
J

Jerry Whittle

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.
 
M

Mark Kubicki

the external files will be deleted; only specific tables within those files
have information that needs to be included in the new files.
 
Top