Excel ODBC DSN connection string with PHP

Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on email

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

Custom Reports and Dashboards

We will build you a set of custom reports and dashboards
Best Offer

The Core Tools

Create dashboard for any Database

Data Visualizer and Dashboard Application
SALE
This is the best dashboard software for its price. One good thing we did was to hire their consulting services to build few dashboard prototypes and provide some quick dashboard training.
- Terry Seal, IL
We evaluated Xcelsius and Qlikview and the cost for organization to implement dashboards was quoted over 10,000 USD. For fraction of the above quoted price, we were able to buy the licenses for the web based dashboard software and get some free training. This is truly a dashboard software for small businesses like us.
IT Manager of a Trucking company, OH