MS Query problem after upgrade to MS Excel 2007

S

Sam

Hi,

I have done a excel file by using MS query to get the data from the other
excel file (not in the same file) while I am using MS Excel 2003. It running
very smooth without any problem.

However after I upgrade my Excel version to 2007, the problem occur, keep
telling me that "[Microsoft][ODBC Excel Driver] Too few parameters. Expected
3." or "Expected 1" or else, and totally i can't update my file, the linkage
seen broken. I try to redo the query but it does not allow, it seen like
don't allow me to link with that excel file (data).

What should I do to overcome this problem?

Appreciate your help.
 

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

Top