[ASP] Open and Order CSV file

[viki1967]

Hi all.

I need open with ASP one CSV file and order this file with field DESCRIPTION.

Can you help me?

kind regards
viki

[jhardman]

I googled the following words: "csv ado db driver asp"

This was the top hit: "http://www.simongibson .com/intranet/adooledb/"

Here is the code they provided:

<%@LANGUAGE=VBSCRIPT%>
<%
Option Explicit
Dim strConnection, conn, rs, strSQL

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath(".\csv\") & ";Extended Properties=""text;HDR=Yes;FMT=Delimited"""

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

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

rs.MoveFirst
WHILE NOT rs.EOF
     Response.Write(rs("myColumn") & "<br/>")
rs.MoveNext
WEND

rs.Close
Set rs = Nothing

conn.Close
Set conn = Nothing
%>

To sort by a specific field, you would want to change the strSQL to be "SELECT * FROM myFile.csv ORDER BY description"

Jared