Connectnig My Access Database (2002) to Excel 2002

T

Tangier

I am simply trying to run my query in excel from an access table.

So far I have the following:

With ActiveSheet.QueryTables.Add(Connection:= _
"ODBC;DRIVER=(What is the driver I should eb using?);
(What other parameters do I need here?),
Destination:=Range("A1"))

Thanx!
 

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

Connecting My Access Database to Excel 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
How to assign query results to cells 0
Excel - Wich Function should I use? 1
Using Access Database to build contracts with fields on pdf document 0
[Microsoft][ODBC Microsoft Access Driver] Could not find installableISAM. 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Table Security in Access 2013 1

Top