OPEN A CSV FILE THEN UPDATE

[gsc123]

Hello,

I need help to open a csv file look for a field, say field4 then update that row on all rows, can anyone help

 

[Sheco]

Have you considered using the FileSystemObject together with built-in fuctions like Replace?

Also, the ADO text driver is good for searching text files but I believe it is read-only.

 

[gsc123]

That would be great, any examples?

 

[johnwm]

Yep - loads at

http://www.w3schools.com/vbscript/func_replace.asp

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[guitarzan]

You could also open the CSV file as an ADO recordset, in which case you could just run an SQL UPDATE on it. A quick search here brings up this thread;

thread333-1237787

 

[guitarzan]

Oops I missed Sheco's comment...

 

[gsc123]

I can tell you want I want to do, I want to update 3 columns on any number of rows to the amount of files in a folder and thus adding the title to these 3 columns? I have the asp for collecting the files but not the spreadsheet