Link to home
Start Free TrialLog in
Avatar of Jesper Christensen
Jesper Christensen

asked on

Classic asp read from url

Hi.

I need to read all lines from a csv file online.

Set xmlhttp = Server.CreateObject("MSXML2.ServerXMLHTTP.6.0")
xmlhttp.Open "GET", "http://www.url.dk/files/file.csv" , False
xmlhttp.Send
txt = xmlhttp.responseText
Set xmlhttp = Nothing

Now i have the file in the variable txt.
How does i read from txt now.

something like http://www.w3schools.com/asp/met_readall.asp
But I cant read from stream.

In asp.net it´s easy, just like:
StreamReader SR = new StreamReader(txt, Encoding.Default);
But how is this possible in classic?
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jesper Christensen
Jesper Christensen

ASKER

Arhh yes of couse :) Thx man