ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   create recordset from csv file on web (https://www.excelbanter.com/excel-programming/274181-create-recordset-csv-file-web.html)

Robbie[_2_]

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



All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com