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
 
Back
Top