Connecting My Access Database to Excel

  • Thread starter Thread starter Tangier
  • Start date Start date
T

Tangier

I simply want to connect my Access database to Excel and run a query
in Excel. What would the connection string for this be if I am using
Access and Excel 2002?

I have the basic skeleton for the connection string:

With ActiveSheet.QueryTables.Add(Connection:= _
"ODBC;DRIVER=(What would the driver be);
, Destination:=Range("A1"))

What other parameters do I need????

THANK YOU!
 
Back
Top