Excel 2003- Too Few Parameters- Import xternal data issue

S

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.
 

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

Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
ODBC Driver Too Few Parameters - Import External Data from Access 1
Excel does not accept text format! 0
PERFORM ACTION ON HITTING ENTER 1
Too few parameters error with a IIF statement 5
Error Message when connecting pivot table to Access DB query 0
Excel 2013 Pivot Data Range formula reference problem 0

Top