View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sam Sam is offline
external usenet poster
 
Posts: 699
Default MS Query problem after upgrade to MS Excel 2007

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.