Connecting My Access Database to Excel

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connectnig My Access Database (2002) to Excel 2002 1
Using Access Database to build contracts with fields on pdf document 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
How to assign query results to cells 0
Word macro that can call cells out of Excel for a find and replace 0
Autonumber field in Excel that behaves the same as Access 0
Table Security in Access 2013 1
A couple questions BEFORE using Office 365 0

Top