excel question

[DzemoT.]

i have oledb connection with this string
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Downloads\sase2.xls;Extended Properties="Excel
8.0;HDR=Yes;IMEX=1"" and work fine with normal *.xls file but when file is
saved as web page i get error initializing connection. What i need to do to
read that excel document?
thx

 

[Miha Markic [MVP C#]]

Hi,

You want to import web page as an excel file?
I don't think you'll be able to.

 

[Paul Clement]

¤ i have oledb connection with this string
¤ "Provider=Microsoft.Jet.OLEDB.4.0;Data
¤ Source=C:\Downloads\sase2.xls;Extended Properties="Excel
¤ 8.0;HDR=Yes;IMEX=1"" and work fine with normal *.xls file but when file is
¤ saved as web page i get error initializing connection. What i need to do to
¤ read that excel document?
¤ thx
¤

Once you've save Excel as a web page it is in HTML format. The Excel driver cannot read this format.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)