Excel ODBC DSN connection string with PHP

When using Excel ODBC with PHP please use the following settings

All settings are done in the connection_methods.php

Windows 7 and Excel 2007

(support for .xls, .xlsx, .xlsm, .xlsb)


$db_url="DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};FIL=Excel 12.0;DriverID=1046;Dbq={$excelFile};DefaultDir={$excelDir};ImportMixedTypes=Text";


Windows XP and older Excel (just .xls)


$db_url="Driver={Microsoft Excel Driver (*.{$fileinfo['extension']})} ;DriverId=790;Dbq={$excelFile};DefaultDir={$excelDir};ImportMixedTypes=Text";