View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robbie[_2_] Robbie[_2_] is offline
external usenet poster
 
Posts: 3
Default create recordset from csv file on web


Is it possible to process csv files located on the web,
such as

http://chart.yahoo.com/table.csv?
s=AA&a=6&b=22&c=2003&d=7&e=11&f=2003&g=d&q=q&y=0&x =.csv

using recordsets, and in such a way that I can use the
ODBCTimeOut property to limit the amount of time spent
trying to access the file? If so, a sample procedure for
creating such a recordset would be greatly appreciated
(I've never used ODBC but do use DAO).

Robbie Geary