StumbleUpon
Share on Facebook

Monday, February 2, 2009

ADO Connection String for Excel

Excel Connection Strings

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Orginal.xls;Extended Properties=Excel 8.0;Persist Security Info=False"

2 comments:

Tarkan VURAL said...

Alternative Sample :
With or without column header ...

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\MyExcelFile.xls;Extended Properties=""Excel 8.0;iif(hdr,yes,no)"""

Tarkan VURAL said...

Alternative Sample :
With or without column header ...

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Orginal.xls;Extended Properties=""Excel 8.0;iif(hdr,yes,no)"""

Related Posts Plugin for WordPress, Blogger...