Append an export

[Xenix]

Hello,

does anybody know how to append an exported excel file from access 2k?

I have the code:
DoCmd.OutputTo acOutputQuery, "QuotationEmail", acFormatXLS, "QuotesUpdate.xls"

I do this on every quotation completed so you can see what happens, it overights the last one done and I end up with one quotation in the xls file at the end of the day

Thank you in advance

Mike

 

[simongallop]

Why not change the code of the query to output all quotations for the day?

 

[Xenix]

Well that would be ok but I have business class and office munchkins using this database and as you know there not too bright to click a simple button before they open the excel document would just be too much.

So I have to find a way that would automatically write the file.

as soon as they open the spreadsheet it's easy I just execute a macro to pull in the correct data to each cell