E
Eric
I'm having a problem connecting a database I'm trying to
build to the Internet. (I posted this to the Tables &
Database Design newsgroup by mistake.)
I'm trying to download a .csv file for use in a database,
but I keep getting this error. I'm running Access 2000 SP-
3 under Win2kPro. I thought this was an issue only with
Access 97? At any rate, I've found mstext35.dll and
msxbse35.dll (although I don't think I need the latter),
and I've been unable to locate a copy of msexcl35.dll.
(Unfortunately, I haven't been able to get regsvr32 to
register these--it keeps saying it can't find the module,
even though they show up just fine in Explorer.)
The code I'm running that produces the ISAM error is this:
strPath = "URL;http://quote.yahoo.com/d/quotes.csv?s="
& FetchStr & "&f=" & YahooControlStr & "&e=.csv"
conn.Open "Provider = Microsoft.jet.OLEDB.4.0; Data
Source =" & strPath
where FetchStr correctly resolves to a series of stock
quotes, and YahooControlStr correctly resolves to a series
of data types to be fetched (e.g., company name, price,
etc).
Any help would be greatly appreciated.
Eric Hines
build to the Internet. (I posted this to the Tables &
Database Design newsgroup by mistake.)
I'm trying to download a .csv file for use in a database,
but I keep getting this error. I'm running Access 2000 SP-
3 under Win2kPro. I thought this was an issue only with
Access 97? At any rate, I've found mstext35.dll and
msxbse35.dll (although I don't think I need the latter),
and I've been unable to locate a copy of msexcl35.dll.
(Unfortunately, I haven't been able to get regsvr32 to
register these--it keeps saying it can't find the module,
even though they show up just fine in Explorer.)
The code I'm running that produces the ISAM error is this:
strPath = "URL;http://quote.yahoo.com/d/quotes.csv?s="
& FetchStr & "&f=" & YahooControlStr & "&e=.csv"
conn.Open "Provider = Microsoft.jet.OLEDB.4.0; Data
Source =" & strPath
where FetchStr correctly resolves to a series of stock
quotes, and YahooControlStr correctly resolves to a series
of data types to be fetched (e.g., company name, price,
etc).
Any help would be greatly appreciated.
Eric Hines