Display information from CSV file on website

[Richo1980]

Hi everyone,

Apologies if this is not the correct forum to post this in...

I am trying to display information from a csv file on a website. This is what I have so far...(I know this is wrong, but I've only extracted info from Access databases before using SQL )

<%
set conn=Server.CreateObject("ADODB.Connection")
Conn.Open "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq="& strPath &";Extensions=asc,csv,tab,txt;Persist Security Info=False"
strFile = "HD_Closed.csv"
strPath = "\\server\c$\inetpub\[URL unfurl="true"]wwwroot\Stats\Stats\db2"[/URL]

'set rs = Server.CreateObject("ADODB.recordset")
rs.Open "select HD_Name, Total FROM "& strFile &""
%>

<table align="center" border="1" size="100%">
	<tr>
		<td class="hnav">
			<b>Name</b>
		</td>
		<td class="hnav">
			<b>Total</b>
		
	</tr>	
<%for each x in rs.Fields
    next%>
</tr>
<%do until rs.EOF%>
    <tr>
    <%for each x in rs.Fields%>
       <td><%Response.Write(x.value)%></td>
    <%next
    rs.MoveNext%>
    </tr>
<%loop
rs.close
conn.close
%>

Could anyone please tell me what I am doing wrong?

Thanks
Samantha

 

[nickdel]

yup, wrong forum, your looking for ASP forum333.

A csv file is essentially a text file so I would recommend using "scripting.filesystemobject". Look this up on google and you will find plenty of examples of how to pull this in and then "split" each value by it's delimiter.

Nick

 

[BillyRayPreachersSon]

Richo,

Why is it in some of your posts you call yourself Dave, and in some you call yourself Samantha? You're not trying to solicit quicker help by pretending to be a female, are you?

Just interested ;-)

Dan

Coedit Limited - Delivering standards compliant, accessible web solutions

[tt]Dan's Page [blue]@[/blue] Code Couch

http://www.codecouch.com/dan/

[/tt]