SQL and Excel

  • Thread starter Thread starter pcw
  • Start date Start date
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
 
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.

--
 
You must log in or register to reply here.

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

Open a word mail-merge document from Excel VBA 1
import Excel worksheet to SQL Server table 7
Can function be used within SQL statement? 2
Excel SQL VBA Command Reference. 1
Push data from Excel to SQL Server 2
Example Of VBA SQL Statement 0
Problem in Excel 2007 when Range beyond 65536 in SELECT statement 2
SQL in vba using excel sheet as my table 2

Back
Top