I am trying to find out how to insert a record into a excel 2007 workbook. I have a sheet called Requests that I would just like to add a new row to when I run my script but I can't figure out the proper syntax. I have attached my current code.
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.open"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\\Inetpub\\db\\OfficeSpaceSummary.xlsx; Extended Properties=""Excel 12.0 Xml; HDR=YES; IMEX=1"";"
RS.Open "INSERT INTO [Requests$] (FirstName) VALUES ('1')"
Set RS = Nothing