I'm trying to create an connection to a file with an .csv extension. Using the normal method to connect to a database is not working could someone please show me how to connect and open .csv files.

--Connection.asp--

<%
  Dim objConn
  Set objConn = Server.CreateObject("ADODB.connection")
  objConn.open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
               "Data Source=c:\Inetpub\wwwroot\compute3\Equity_Pack_Bas ic_2005-03-30-1030.csv"
%>


--Home.asp--

 <%
 Dim rsComList
 Set rsComList = Server.CreateObject("ADODB.Recordset") r
 rsComList.Filter = "IN_ISEQ = Y"
 rsComList.Open objConn, adOpenForwardOnly, asLockOptimistic,
 adCmdTable

 do while NOT rsComList.EOF
   Response.write _
     "<tr class=""evenRow"">" & _
       "<td>" & rsComList("ISSUER_NAME") & "</td>" & _
       "<td>" & rsComList("OPEN_PRICE") & "</td>" & _
       "<td>" & rsComList("OFFICIAL_CLOSING_PRICE") & "</td>" & _
       "<td>" & rsComList("DAILY_HIGH") & "</td>" & _
       "<td>" & rsComList("DAILY_LOW") & "</td>" & _
     "</tr>"
   rsComList.MoveNext
 Loop
%>

Try connecting through Excel, as shown in this example: http://www.dotnetjohn.com/articles.aspx?articleid=54

Brian