SQL Database

  • Thread starter Thread starter Julie
  • Start date Start date
J

Julie

Hi all! Is there a way that you can access a SQL
Database using VBA in Excel? If so, how would I make
that connection? Thanks in advance and Happy Holidays!

Julie
 
Yes, place the following code ActiveSheet.QueryTables.Add
double click on QueryTables and press F1 for help. You'll
find all answers and examples here to complete your task.

regards
KM
 
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

What are the steps to fix damaged MDF files in SQL Server? 0
sql to database 2
Get results from Access Database. 1
Can function be used within SQL statement? 2
Link, drop link, relink 2
Excel as front end and SQL Server as back end 0
Running a SQL query off an excel table of data 1
Open a word mail-merge document from Excel VBA 1

Back
Top