• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1001
  • Last Modified:

Export Access 2007 Query to Excel 2007+

Hi,

I am trying to export the results of a query to excel so that i can use the excel sheet on my tablet pc.

However, when the excel sheet is saved to my pc it is in "2003-2007" format and this is not compatible with my tabet pc.

I need to change my code (below) so that the excel file is in a later format than 2003-2007.

Can anyone help please?

DoCmd.OutputTo acOutputQuery, "MSSL Customer Details", "Excel97-Excel2003Workbook(*.xls)", "", True, "", 0, acExportQualityPrint

I have also tried the following code but this is no good either:

DoCmd.OutputTo acQuery, "MSSL Customer Details", "MicrosoftExcel(*.xlsx)", "", False, ""

Many thanks
0
andrewpiconnect
Asked:
andrewpiconnect
1 Solution
 
Rey Obrero (Capricorn1)Commented:
try using



DoCmd.OutputTo acOutputQuery, "MSSL Customer Details", "Excel Workbook(*.xlsx)", "", True, "", 0, acExportQualityPrint
0
 
andrewpiconnectAuthor Commented:
works a treat....many thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now