Export from Access 2007 to Excel 2007

[Hemish]

Hi i have just upgraded from Access 2000 to Acces 2007. I am using my vba script to export data but for some reason it does not like Access query exporting into excel.

Below is my code


DoCmd.OutputTo acOutputQuery, "qryCustomerSalesAndStockOfferExport", acFormatXLS, "c:\StockOfferLog\CustomerStockSalesAndOffer.xls", False

Can anyone please help me as i am stuck

Thank toy for your help

 

[rainman89]

DoCmd.OutputTo acQuery, "qryCustomerSalesAndStockOfferExport", "MicrosoftExcel(*.xls)", "c:\StockOfferLog\CustomerStockSalesAndOffer.x ls", False, ""

Try that. Thats what I use

 

[HiTechCoach]

Hemish,

Have you installed the Office 2007 SP2 update?

 

[Hemish]

Hi

I installed the Service pack 2 this morning and it still was not working. I tried the code from above and it works fine, its was fairly simple.

Thank you very much for your help

 

[HiTechCoach]

Glad you got it working ....