Tuesday, September 26, 2006

Using MS Excel as Database : ADODB

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


The rest is the usual ADO recordset retrieving technique

No comments:

Post a Comment

Share on Facebook
Related Posts Plugin for WordPress, Blogger...
Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.