We have an Excel spreadsheet that accesses a file on one of our network drives.
This program was written by an ex-employee and seems to be using some sort of 'DSNless' connection to a CSV file.
The problem is that when we try to run it on a different server we get the folowing error:
[Microsoft][ODBC Text Driver] The Microsoft Jet Engine could not fine the object 'RunDMC.csv'. Make sure the object exists and that you spell its name and path name correctly.
When we run it on a Windows 2000 or Windows XP PC there are no issues. When we run it on this particular Windows 2000 Server we get the error.
All other Excel queries on this same server run fine with standard ODBC connections to our Oracle database.
Any help appreciated.
Regards,
Andy.
This program was written by an ex-employee and seems to be using some sort of 'DSNless' connection to a CSV file.
The problem is that when we try to run it on a different server we get the folowing error:
[Microsoft][ODBC Text Driver] The Microsoft Jet Engine could not fine the object 'RunDMC.csv'. Make sure the object exists and that you spell its name and path name correctly.
When we run it on a Windows 2000 or Windows XP PC there are no issues. When we run it on this particular Windows 2000 Server we get the error.
All other Excel queries on this same server run fine with standard ODBC connections to our Oracle database.
Any help appreciated.
Regards,
Andy.