Thread: "Invalid internet address" during ADO
View Single Post
  #1   Report Post  
Posted to microsoft.public.data.ado,microsoft.public.excel.programming
Dean Frazier Dean Frazier is offline
external usenet poster
  
Posts: 3
Default "Invalid internet address" during ADO
I'm trying to access an Excel file on the internet via ADO, and get an
"invalid internet address" error message. Here's the code.

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & "http://www.mysite.com/myfile.xls" & ";" & _
"Extended Properties=""Excel 8.0;HDR=Yes"""

It works for a local file, just not for a file on the internet.

Any suggestions?

Thanks,
Dean
Reply With QuoteReply With Quote