I am getting this error continuously
[Microsoft] [ODBC Excel Driver]The connection for viewing your linked excel worksheet was lost
The piece of code which is resulting in this:
connExcel.Open connStringExcel
sSQLSting = "SELECT * From [Project Detail Data Dump$A1:BH47]"
rstExcel.CursorLocation = adUseClient
rstExcel.Open sSQLSting, connExcel
Please note, the same code was working very fine earlier. When searched, I found its happening due to memory leaks. I have saved the worked as a new copy, Quit the excel (Closing and reopening the file), but nothing is working.
Can somebody please help on this error?
[Microsoft] [ODBC Excel Driver]The connection for viewing your linked excel worksheet was lost
The piece of code which is resulting in this:
connExcel.Open connStringExcel
sSQLSting = "SELECT * From [Project Detail Data Dump$A1:BH47]"
rstExcel.CursorLocation = adUseClient
rstExcel.Open sSQLSting, connExcel
Please note, the same code was working very fine earlier. When searched, I found its happening due to memory leaks. I have saved the worked as a new copy, Quit the excel (Closing and reopening the file), but nothing is working.
Can somebody please help on this error?
