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.
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.
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;"
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.