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
.