ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   MS Query problem after upgrade to MS Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/169510-ms-query-problem-after-upgrade-ms-excel-2007-a.html)

Sam

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.


All times are GMT +1. The time now is 03:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com