The problem that I encountered is that Excel 2007 adds something to the spreadsheet even when it is saved as an Excel 2003 spreadsheet. When I compared the original Excel 2007 spreadsheet with an Excel 2003 spreadsheet with the same content, the version created in Excel 2007 was 9 Kb larger...
Many thanks to both of you for your suggestions. Both use ODBC (which confirms the direction I was planning to take), and Cetin Basoz's solution includes a code sample for writing to Excel 2007 spreadsheets. [2thumbsup]
Has anyone come up with a solution? There was a thread dealing with this problem (thread1251-1338029), but it was closed in August 2007. At this time, the only solution that I can come up with is to open the offending file in Excel 2003, create a new spreadsheet and copy & paste contents of the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.