Monthly Archives: March 2006

Excel ODBC Driver Woes

Recently, I’ve been working on a project that involves reading a batch of data using an ASP script. I wanted the bulk of the code to be able to operate on a standard MSSQL database OR read the same data from a static Excel file. On the surface, the Microsoft Excel ODBC driver seems like a natural choice. However, as you will see the best advice is to stay far, far away from this driver. Continue reading

Posted in Programming | 7 Comments