Excel VBA Load spreadsheet with data from SQL Query

Murray Brown
Murray Brown used Ask the Experts™
on
Hi

What Excel VBA code would I use to connect to a SQL database using an OLEDBConnection and pull
data into an Excel spreadsheet? I am looking for an example.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2015

Commented:
This is the best site that i can tell you for connection strings which you are looking..

Check Here

Saurabh...
Murray BrownASP.net/VSTO Developer

Author

Commented:
Thanks very much

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial