Microsoft Access Export to Excel
The first and easiest option is to select the "External Data" option on the top and select Excel from the Export Data options. This lets you customize the export location and if you want to keep the Access formatting. If you wanted a different format you would have to manually change the column order before exporting to achieve this. If your referring to it not looking the same as before in Excel because it was a table there is a quick fix. Use the keyboard shortcuts ctrl + Home > ctrl + A > ctrl + L to create a table object which formats it nicely.

You can save this manual export process and re run it manually or in a macro if you choose to in the future. This saves time with manually recreating the export each time.

A more advanced option would be creating a VBA module to do the exporting and formatting keyboard shortcut for you. I have the code you can copy and paste from Access to Excel Export Code. You could additionally customize this code to format the columns in the correct order. I would recommend looking into the fld.OrdinalPostion property to do this here Microsoft Field.OrdinalPostion