I am trying to insert data from one Access database from another...I can get the following query to work on a remote Access database...
however, I need to include an inner join like so:
so ultimately, i need to insert data into a local Access table with data from another Access database table(s) inner join
is this possible? if not...suggestions?
Setup:1. 1 local Access database - contains vba module to loop through Access files (via FSO)2. multiple 'remote' (for the sake of simplicity - located in same directory as local) Access files - contains the data from which appends to local table
*** note - placed in multiple threads - will update if fix action found
thanks!
Code:
sSQL = "SELECT * FROM Activity IN """ & sRtdPath & """"
however, I need to include an inner join like so:
Code:
sSQL = "SELECT DISTINCT Machine.DisplayField, Machine.ValueField, Activity.IP FROM Activity INNER JOIN Machine ON Activity.ID_ = Machine.ActivityID WHERE Machine.DisplayField='OS Detected' AND Machine.ValueField<>'foo' AND Machine.ValueField NOT LIKE '%this%' AND Machine.ValueField<>'this';"
so ultimately, i need to insert data into a local Access table with data from another Access database table(s) inner join
is this possible? if not...suggestions?
Setup:1. 1 local Access database - contains vba module to loop through Access files (via FSO)2. multiple 'remote' (for the sake of simplicity - located in same directory as local) Access files - contains the data from which appends to local table
*** note - placed in multiple threads - will update if fix action found
thanks!