VB code to query two tables in different databases

  • Thread starter Thread starter UB
  • Start date Start date
U

UB

Is it possible to write a VB query that joins one table
in each of two databases on a common ID field in each
table.
 
For each data table in the query, use the IN word in your
SQL query to specify the input filename.
 
Hi UB,

Do you mean a SQL query? You can use the IN clause as suggested
elsewhere - or if you're working in Access it's usually more convenient
to set up each of the tables as a linked table (File|Get External
Data|Link) and then write the query exactly as if they were ordinary
Access tables.
 
Back
Top