Connecting to an excel sheet using ADO's
Posted on 2002-03-21
I have tried to connect to an excel workbook using ADO's, but when I try to set a recordset to a worksheet, I am getting an error because the Sheet names end with a $ (eg. Sheet1$,Sheet2$). Connection is successful, problem comes when I try to open the worksheet.