using external data

[andyc209]

I have a CSV file from an external source and I want to be able to use this data within my webpage.

an example of the csv is

date1, date2, date3 etc

what I want to do is to be able to extract date2 from this csv and put it somewhere on my page. Can I do this in ASP or do i have to import it into SQL and access it there? If I do have to use my SQL database how can I get this to access it every half hour as the values in the csv are always changing.

 

[onpnt]

If the format is consistant then you can use FSO and split the line on the delimiter (,). That way you have a array of the record and you simply point to the one you want being data2.

If this is going to be a job that is common and something of a batch task as far as the CSV goes I would use SQL Server or Access on the backend then and do a nightly import. It will be far more effecient and the users then will have a better experience sense the main processing tasks will be done prior to the visit


____________ signature below ______________
General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[damber]

You can always access the CSV via ADO and treat it like a normal recordset.

Check out the ADO connection string you need here:

http://www.codeproject.com/database/connectionstrings.asp#Text

A smile is worth a thousand kind words. So smile, it's easy!