hello,
i want to update the .csv file using ado in asp. i have written following code
connCSV.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & path1 & ";" & "Extended Properties=""text;HDR=YES;FMT=Delimited"""
set rs1=connCSV.execute("select * from "&filenm)
rs1.close
rs1.locktype = adLockPessimistic
rs1.cursortype = adopendynamic
rs1.cursorlocation = aduseclient
rs1.open
rs1.movelast
rs1.fields("Auserid")=userid
rs1.fields("DOD")=now()
rs1.update
it giving me error at line rs1.update as "Updating data in a linked table is not supported by this ISAM. "
is it possible to update .csv file using ADO? if yes then please tell me the code of it.
i want to update the .csv file using ado in asp. i have written following code
connCSV.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & path1 & ";" & "Extended Properties=""text;HDR=YES;FMT=Delimited"""
set rs1=connCSV.execute("select * from "&filenm)
rs1.close
rs1.locktype = adLockPessimistic
rs1.cursortype = adopendynamic
rs1.cursorlocation = aduseclient
rs1.open
rs1.movelast
rs1.fields("Auserid")=userid
rs1.fields("DOD")=now()
rs1.update
it giving me error at line rs1.update as "Updating data in a linked table is not supported by this ISAM. "
is it possible to update .csv file using ADO? if yes then please tell me the code of it.