Appending data to a table in a different database

[tobydobo]

hello,



Is there a run to run an append query that will append data from DatabaseA to a table in DatabaseB? Im thinking theres got to be a way. Any assistance would greatly be appreciated.

[June7]

Yes. Google: access vba update table another database

Simple example from my project:
Dim strExtract As String
strExtract = gstrBasePath & "Program\Editing\ConstructionExtract.accdb"
CurrentDb.Execute "SELECT * INTO Bituminous IN '" & strExtract & "' FROM ConstructionBIT;"