View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
simsjr simsjr is offline
external usenet poster
 
Posts: 19
Default Too few parameters. Expected 1.

Ok, using Office XP, I'm trying to use the DataImport External DataNew
Database Query feature to bring data into my spreadsheet. I'm trying to use a
query located in example.mdb to do this.

Example.mdb contains nothing but link tables, but I am able to run my query
in Access just fine. When I select example.mdb as my external data source,
choose one of the queries located therein, and click 'Finish', I get the
following error message:

"Too few parameters. Expected 1."

....Then the import process dies and I'm left staring at a blank spreadsheet.

What is causing this? I've imported data this way before with no problems.