UPDATE QUERY FOR CSV FILE

[gsc123]

Hello,

how do I update on a csv file? I'm parsing through asp and updated certian columns , is there some way of getting the row id? because unlike access or sql having primary keys, what does csv files use? they are rows

ie: update something set whatever where ?? = recordset number?

 

[Sheco]

Have you considered using the FileSystemObject and treating it as a text file?

 

[Sheco]

The reason I mention that is I think the text driver is opens it read-only.