How to export access 2013 report to excel 2013?

I only see .xls format available, there is no .xlsx to select.

thanks
untitled.bmp
HemlockPrintersAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nick67Commented:
And?
Excel 2013 will open .xls files just fine
If you really need the export to be .xlsx, you can do a SaveAs from within Excel to convert it.
0
Jeffrey CoachmanMIS LiasonCommented:
Agree with Nick, ...but going a bit further...
Remember, ...If you are just exporting the raw data from Access, then none of the xlsx features come into play anyway.

Just note that it is FAR better to export the reports underlying record source than the report itself.
Some issues with exporting reports include:
1. Depending on your Reports layout/design, ...the exported data may be misaligned
2. Any "calculated" values in the report will be static in Excel
3. You will not export any formats/formatting

There are hundreds of posts here where members are asking why exported reports don't "look the same" as the Access report.

If the source for the report is a simple table or query then the code is simple:
 
DoCmd.TransferSpreadsheet acExport, , "YourTableOrQueryName", "C:\YourFolder\YourFile.xlx"

Open in new window


If you need formatting, ...then this can be done in Excel after the data is imported.

JeffCoacman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.