Oprette ny post i excel fil
Hvorfor kan jeg ikke oprette en ny post i excel filen med dette script....den giver følgende fejl:[Microsoft][ODBC Excel Driver] Operation must use an updateable query.
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open "DBQ=" & Server.MapPath("excel.xls") & ";" & _
"DRIVER={Microsoft Excel Driver (*.xls)};"
StrExcel = "SELECT * from `Ark1$`"
Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open StrExcel, myConn, 1, 3
RS.AddNew
RS.Fields("Navn").Value ="Mona"
RS.Fields("Alder").Value ="28"
RS.Update
