How to read CSV files line by line in VBScript
Do not try to parse the file yourself, you’ll just give yourself a headache. There’s quite a bit more to it than splitting on newline and commas. You can use OLEDB to open up the file in a recordset and read it just as you would a db table. Something like this: Dim strConn, conn, … Read more