The following table shows how you can use the IN clause to retrieve data from an external database. In each example, assume the hypothetical Customers table is stored in an external database.
External database | SQL statement |
||
Microsoft Jet database | SELECT CustomerID FROM Customers IN OtherDB.mdb WHERE CustomerID Like "A*"; |
||
dBASE III or IV. To retrieve data from a dBASE III table, substitute "dBASE III;" for "dBASE IV;". |
SELECT CustomerID FROM Customer IN "C:\DBASE\DATA\SALES" "dBASE IV;" WHERE CustomerID Like "A*"; |
||
dBASE III or IV using Database syntax. | SELECT CustomerID FROM Customer IN "" [dBASE IV; Database=C:\DBASE\DATA\SALES;] WHERE CustomerID Like "A*"; |
||
Paradox 3.x or 4.x. To retrieve data from a Paradox version 3.x table, substitute "Paradox 3.x;" for "Paradox 4.x;". |
SELECT CustomerID FROM Customer IN "C:\PARADOX\DATA\SALES" "Paradox 4.x;" WHERE CustomerID Like "A*"; |
||
Paradox 3.x or 4.x using Database syntax. | SELECT CustomerID FROM Customer IN "" [Paradox 4.x;Database=C:\PARADOX\DATA\SALES;] WHERE CustomerID Like "A*"; |
||
A Microsoft Excel worksheet | SELECT CustomerID, CompanyName |
||
A named range in a worksheet | SELECT CustomerID, CompanyName |