tag:blogger.com,1999:blog-7883769006508081360.post3571545545534974464..comments2023-10-29T02:31:18.425-07:00Comments on SQL Tips & Tricks: ADO Connection String for ExcelUnknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7883769006508081360.post-20326700436269561422009-02-17T00:55:00.000-08:002009-02-17T00:55:00.000-08:00Alternative Sample :With or without column header ...Alternative Sample :<BR/>With or without column header ...<BR/><BR/>"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Orginal.xls;Extended Properties=""Excel 8.0;iif(hdr,yes,no)"""Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7883769006508081360.post-54815601283901357732009-02-17T00:54:00.000-08:002009-02-17T00:54:00.000-08:00Alternative Sample :With or without column header ...Alternative Sample :<BR/>With or without column header ...<BR/><BR/>"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\MyExcelFile.xls;Extended Properties=""Excel 8.0;iif(hdr,yes,no)"""Anonymousnoreply@blogger.com