If are a diehard ADO user. Here is the connection string for Excel
sXL = "c:\DaniWebExample.xls"
Set Cn = New ADODB.ConnectionCn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" & sXL & ";Extended Properties=Excel 8.0;Persist Security Info=False"Cn.ConnectionTimeout = 40
Cn.Open
The rest is the usual ADO recordset retrieving technique
Tuesday, September 26, 2006
Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.
Posts
No comments:
Post a Comment