How to read CSV files line by line in VBScript

by

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, rs

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("path to folder") & ";Extended Properties="text;HDR=Yes;FMT-Delimited";"

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open strConn

Set rs = Server.CreateObject("ADODB.recordset")
rs.open "SELECT * FROM myfile.csv", conn

while not rs.eof
    ...
    rs.movenext
wend

My vbscript is rusty, so verify the syntax.

edit: harpo’s comment brings up a good point about field definitions. Defining a schema.ini file allows you to define the number and datatypes of the expected fields. See: You can handle this by defining a schema.ini file. see: http://msdn.microsoft.com/en-us/library/ms709353.aspx

More Related Contents:

  1. ASP: request.form is not returning value?
  2. Querying Active Directory using VBScript
  3. How to resolve “The requested URL was rejected. Please consult with your administrator.” error?
  4. How to encrypt in VBScript using AES?
  5. Out of memory Microsoft VBScript runtime error 800a0007
  6. Format current date and time in VBScript
  7. Error ASP 0177: 8007007e CreateObject fails for COM DLL
  8. Any good libraries for parsing JSON in Classic ASP? [closed]
  9. Detailed 500 error message, ASP + IIS 7.5
  10. Regex to split a CSV
  11. How can I post data using cURL in asp classic?
  12. How to upload files with asp-classic
  13. How do I properly instantiate 32-bit COM objects in classic ASP after installing Windows Update KB4340558?
  14. Export each sheet to a separate csv file
  15. Parameterized query in Classic Asp
  16. ASP JSON: Object not a collection
  17. convert utf-8 to iso-8859-1 in classic asp
  18. ADODB.Parameters error ‘800a0e7c’ Parameter object is improperly defined. Inconsistent or incomplete information was provided
  19. Compare values of two arrays – classic asp
  20. ADODB.Recordset error ‘800a0bb9’ : Arguments are of the wrong type
  21. How to enable ASP classic in IIS7.5
  22. VBScript to loop through all files in a folder
  23. How to make a parametrized SQL Query on Classic ASP?
  24. How do I use awk under cygwin to print fields from an excel spreadsheet?
  25. Passing Parameters to a Stored Procedure using ASP
  26. Is codepage 65001 and utf-8 the same thing?
  27. HTTP GET Request, ASP – I’m lost!
  28. Download a file using Javascript
  29. Error trying to call stored procedure with prepared statement
  30. Classic ASP (VBScript) convert HTML codes to plain text

Leave a Comment