MS Query Wizard

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
 
J

Jamie Collins

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.

--
 

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

Converting MS query from Excel 2003 to Excel 2007 1
MS Excel Error: Too many client tasks 1
Excel 2000 - Microsoft Query 1
Query Wizard - Choose Columns 3
Too few parameters 3
Can't create a report from my query in Access 1
Pass-Through Query Error 1
Running MS Query on an Excel Spreadsheet 3

Top