SQL Query and connection help

M

Mangler

I would like to have a excel sheet connect to a db and run a query
that can be refreshed. Can someone give me an example on how to do
this with vb in code view?

I found many examples but either none work, or I can get the data to
be displayed on the worksheet.

Excel 2007
 

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

Need Help with Macro Security 1
VBA Coding Help for Beginner 0
Sharing SQL Server connections across Sheets 1
Error Message when connecting pivot table to Access DB query 0
Connection/Refresh Control unavailable for imported XML data 0
Convert column data into multiple rows 1
SQL Query with constraint in a cell 1
Copy Website Tables into Excel 2007 Spreadsheets 4

Top