What is the syntax quering data from multiple Access databases?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the syntax quering data from multiple Access databases? Any
suggestions or examples?
 
ionoloso said:
What is the syntax quering data from multiple Access databases? Any
suggestions or examples?
Click to expand...


Use the IN "path" phrase in the FROM clause.
 
Marshall said:
Use the IN "path" phrase in the FROM clause.
Click to expand...

I find the 'brackets' syntax easier to read e.g.

SELECT key_col, data_col FROM
[MS Access;Database=C:\db1.mdb;].Test
UNION
SELECT key_col, data_col FROM
[MS Access;Database=C:\db2.mdb;].Test
UNION
SELECT key_col, data_col FROM
[MS Access;Database=C:\db2.mdb;].Test
ORDER BY 1;

Jamie.

--
 
onedaywhen said:
I find the 'brackets' syntax easier to read e.g.

SELECT key_col, data_col FROM
[MS Access;Database=C:\db1.mdb;].Test
Click to expand...


It's your call of course, but, for mdb files, I prefer

SELECT key_col, data_col
FROM Test IN "C:\db1.mdb"

I do agree with you when the foreign db requires a full
connect string though.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple user 1
stuck and need help 2
Multiple connections on Access 97 1
Using Excel as a Database 9
Database Query in Excel 1
Can you do an IF function whether a cell has a fill color of Rose 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access Access database invalid syntax error message 0

Back
Top