SQL Database

Julie · Dec 10, 2003

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

KM · Dec 10, 2003

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