Error in MS Query to Excel Sheet..

[Nitesh Khot]

Hi..

How to MS Query to work on another computer...i.e I have below connection string where If i sent this file to someone then he getting error of file path...

How to solve this error to use this file on multiple machine...


Connection String :-

DSN=Excel Files;DBQ=C:\Users\Admin\Desktop\MSQuery.xlsx;DefaultDir=C:\Users\Admin\Desktop;DriverId=1046;MaxBufferSize=2048;PageTimeout=5;

Command Text:-

SELECT `Sheet1$`.`Sr no#`, `Sheet1$`.State, `Sheet1$`.`CityName`, `Sheet1$`.Cluster, `Sheet1$`.Branch_Name, `Sheet1$`.`PO_Name`,
FROM `C:\Users\Admin\Desktop\MSQuery.xlsx`.`Sheet1$` `Sheet1$`
WHERE (`Sheet1$`.Cluster=?)

 

[NARAYANK991]

Hi ,

See if the following has any helpful information :

https://support.microsoft.com/en-us/kb/165866

Narayan