ERROR [07002] [Microsoft][ODBC Excel Driver] Too few parameters. Expected #

[ebell1]

I am using the lookup function to place data into my main report. I have 9 additional datasets and everything is working fine. However when I added my 10 dataset I need to sort the data so that just the last date would show on the report. I wrote the query as

SELECT [Task_Type], [Status_Change_Date],[SourcingEvent]
from [ContractsWorkflowReport$]
ORDER BY
[SourcingEvent],[Task_Type], [Status_Change_Date]

and now I am getting the error that I placed in the subject line. I have tried
SELECT *
from [ContractsWorkflowReport$]
ORDER BY
[SourcingEvent],[Task_Type], [Status_Change_Date]
with the same error.

If I just use the query
SELECT *
from [ContractsWorkflowReport$]
the report will run fine. However without the sort I am not getting the right dates.

Any help is appreciated.

 

[SQLScholar]

Why do have dollar signs at the end of the table names?

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[xlbo]

SQLScholar - It's an excel driver thing...

ebell1 - what happens if you try:

SELECT [Task_Type], [Status_Change_Date],[SourcingEvent]
from [ContractsWorkflowReport$]


Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question