View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GB GB is offline
external usenet poster
 
Posts: 230
Default 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