RaoulD
03-10-2011, 07:22 AM
Hi,
I have an Excel file that uses ADO to connect to one of the sheets and uses it as a database to store and extract data. The connection string that I use works fine with a C:\ or D:\ etc in the string -
sConnect = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=D:\Raoul\Path\Dashboard_v1.2.xlsm;" & _
"Extended Properties=Excel 12.0;"
However, this file needs to be relocated to a network drive that is named "\\NetworkFolder\NetworkFolder1".
sConnect = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=\\NetworkFolder\NetworkFolder1\Dashboard_v1.2.xlsm;" & _
"Extended Properties=Excel 12.0;"
When I substitute this for the c:\ or d:\ I get an error that the path is not found. Could someone please help me with this?
Thanks,
Raoul
I have an Excel file that uses ADO to connect to one of the sheets and uses it as a database to store and extract data. The connection string that I use works fine with a C:\ or D:\ etc in the string -
sConnect = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=D:\Raoul\Path\Dashboard_v1.2.xlsm;" & _
"Extended Properties=Excel 12.0;"
However, this file needs to be relocated to a network drive that is named "\\NetworkFolder\NetworkFolder1".
sConnect = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=\\NetworkFolder\NetworkFolder1\Dashboard_v1.2.xlsm;" & _
"Extended Properties=Excel 12.0;"
When I substitute this for the c:\ or d:\ I get an error that the path is not found. Could someone please help me with this?
Thanks,
Raoul