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”;