Writing to Excel using ODBC

[MrShawn]

Hi guys I am trying to write to excel file using ODBC and QSql objects.

I am at the point where I can connect and seem to be able to execute queries.

The problem I have now that the file only exists during the lifetime of the program. Once I close the DB connection it goes away, unless the file is already created. Is there a way to get around this issue without bringing in some other library to generate the file?

If the answer is no - what method / library is suggested. I do not want to export to a .csv. Id rather it be a .xls or xlsx.

Thanks :)

Shawn

[hskoglund]

Hi, to make the file persist, couldn't you just issue a SaveAs() before closing the DB connection?