What is the best way to open a connection,and execute a SQL command on an excel spreadsheet?
I don’t seem to have a problem opening the connection, but when I attempt to open a recordset using this connection : rsOpenACT.Open “Select * from Spreadsheet” I get an Error :”[Microsoft][ODBC Excel Driver]. The Microsoft Jet database engine could not find the object ‘Spreadsheet’. Make sure the object exists and that you spell its name and the path name correctly.”
I think all I really need is a sample Connection String, and a sample Recordset.Open method.
