Pages

▼

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"
at

2 comments:

  1. AnonymousFebruary 17, 2009 at 12:54 AM

    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)"""

    ReplyDelete
  2. AnonymousFebruary 17, 2009 at 12:55 AM

    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)"""

    ReplyDelete