ExcelBanter - Invalid internet address

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Invalid internet address (https://www.excelbanter.com/excel-programming/350626-invalid-internet-address.html)

Invalid internet address

Hello All,

I used the Oledb connection string as follows

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Test.xls;Extended
Properties="Excel 8.0"

Its working for local path.If i gave the path as

Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=http://localhost/Test/Test.xls;Extended Properties="Excel 8.0"

It throws "Invalid internet address." exception.

Whats wrong in this connection string............?

Please help me....

Regards,
karthik

Invalid internet address

Don't know, but have you tried \'s instead of /'s? *shrug*

" wrote:

Hello All,

I used the Oledb connection string as follows

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Test.xls;Extended
Properties="Excel 8.0"

Its working for local path.If i gave the path as

Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=http://localhost/Test/Test.xls;Extended Properties="Excel 8.0"

It throws "Invalid internet address." exception.

Whats wrong in this connection string............?

Please help me....

Regards,
karthik