>Currently we are able to import from Excel 2007 via the new driver and a query but we only issue a COPY TO command to export to Excel and by default it goes to an older version of Excel. So there is no way in the future to make that go to a Excel 2007 format via a command with out writing code pointed at the object/driver, is that correct? I hadn;t thought about that little tidbit.

It has been the case since Excel 97.