MS Query Wizard

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

Hello, with some of my spreadsheets I get the
error "[Microsoft][ODBC Text Driver] Too few parameters.
Expected 1." when I go through the MS Query Wizard to get
external data from an MS SQL database. Other spreadsheets
work fine. I tried copying and pasting the problem
spreadsheets into a new workbook and then going through MS
Query Wizard again, but still got the error. Could it be
something within the spreadsheet, like formatting? We
tried updating the ODBC Administrator (MDAC) to version
2.7. Any help would be appreciated.

Regards,

Randy
 
Randy said:
I get the
error "[Microsoft][ODBC Text Driver] Too few parameters.
Expected 1." when I go through the MS Query Wizard to get
external data from an MS SQL database.
Click to expand...

Why are you using a text driver for SQL Server data?

Jamie.

--
 
Back
Top