SQL Database
 

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

SQL Database
 

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

-----Original Message-----
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
.