Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Import ACCESS query into EXCEL (DAO? ADO?)

  Asked By: Matilda    Date: Sep 07    Category: MS Office    Views: 1546
  

I have an ACCESS query that can't ODBC with Excel because one parameter
of the query needs to be specified before the query can be ran.

For instance, if I put date=7/15/2005 as the criteria in ACCESS query
and then in excel 2003, I go to data->import data->select the query.
The ODBC will work.

Then I changed the query so that the criteria is not a static value,
instead, ACCESS will pop out a window asking for "What date do you
want?" and then the query will return some result.

The change will destroy the ODBC connection. There is an error message
saying "too few parameters" blah blah....

My question: how to ODBC an ACCESS query that needs to specify a
parameter in the query?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Dannon Jones     Answered On: Sep 07

I think you should build the sql-string in excel  and than run it against the
access database. You can look for an axample at
http://www.excelkb.com/article.aspx?id=10086
<http://www.excelkb.com/article.aspx?id=10086&cNode=1I7C3V> &cNode=1I7C3V

 
Didn't find what you were looking for? Find more on Import ACCESS query into EXCEL (DAO? ADO?) Or get search suggestion and latest updates.




Tagged: