G Guest Mar 10, 2005 #1 What is the syntax quering data from multiple Access databases? Any suggestions or examples?
M Marshall Barton Mar 10, 2005 #2 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.
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.
O onedaywhen Mar 11, 2005 #3 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. --
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. --
M Marshall Barton Mar 11, 2005 #4 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.
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.
