Excel export formatting

[tariq nawaz]

i have a table which i need to export in excel on daily basis.

i can export using the code


"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "input", "z:\Book1.xls", False, "Sheet1$"
"
i got table input and it exports sheet1 in the table called book1.

i saw code on internet and used it for exporting it . i have to create table book1 to be there to export the file. it expots the table but it does not export the formatting and there are a lot of blank rows in export.
i want some code to export the table with formatting as well as it deletes the data what is existing on file book1 everytime i export the file next time.

Regards

A learner