2010 Office System Driver Beta: Data Connectivity Components

http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en


.net framework data provider for odbc (EXCEL) (x86)

connection string = Dsn=test;Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};dbq=c:\book1.xls

.net framework data provider for odbc (EXCEL) (x64)

Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}

Dsn=test

SQL Syntax for EXCEL

select * from [sheet1$]