ODBC Driver Too Few Parameters - Import External Data from Access

[snandula]

Hi..

I'm using Access 2003 and Excel 2003. I made a Pivot chart in Excel
which imported data from Access (using an Access query). However in
my access query the you have to enter 4 other variables like start
date, end date, price. Is there anyway that I can be prompted to enter
these whenever I hit refresh on my pivot table in Excel ?? Right now I
get the ODBC error - too few parameters error.

I have also tried making a new tab in excel where you enter these 4
criteria. This sheet is read as a linked table in Access. However when
I link the results of this table into the access query, the Refresh
function in Excel takes over 30 min to compute. If i enter the dates
manually in Access and then refresh in Excel, the query is done in 1
min.

So is there a work around ??

Thanks in advance.

S

 

[bhicks11 via AccessMonster.com]

Maybe you could trap the error in Excel VBA, when you get that error number,
code it to respond with a Msg and continue on. Do you use VBA?

Bonnie

http://www.dataplus-svc.com