SQL and Excel

G

Greg Koppel

The best way to find the code for you to use is to record a macro while
manually performing a query from Excel using MSQuery (Data/Get External
Data/New Database Query)

HTH, Greg
 
O

onedaywhen

Greg Koppel said:
The best way to find the code for you to use is to record a macro while
manually performing a query from Excel using MSQuery (Data/Get External
Data/New Database Query)
Click to expand...

For VBA code, check out ADO. MS Query is a GUI tool.

--
 
Top