excel question

  • Thread starter Thread starter DzemoT.
  • Start date Start date
D

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
 
Hi,

You want to import web page as an excel file?
I don't think you'll be able to.
 
¤ 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)
 
Back
Top