"Invalid internet address" during ADO

D

Dean Frazier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO connection to Excel 2007 *.xlsx files? 8
ADO Recordset 0
Importing .xlsm, .xlsx with OLEDB 5
export excel data to access table using ADO 0
Invalid internet address 1
VBA Excel data to SQL Sever table 1
Excel instance isolation problem 0
ADO connection not opening in Excel 2003 0

Top