1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Microsoft Access Export to Excel

Discussion in 'Programming/Internet' started by CDZ, Oct 8, 2018.

  1. CDZ

    CDZ Guest

    I have an Excel spreadsheet that is filled with a ton of data which is organized by column (a column for names, a column for occupation etc.). I have recently moved all of this data into Microsoft Access 2010 to work with, but I do require to move this data back and forth between Access and Excel. Since then, I have made a lot of changes to the data and I now want to export this data back from Access into Excel, with the data appearing in the same columns that they were imported in from. I have tried exporting the data back into Excel, but it doesn't look the same as the excel file that I originally exported the data from.

    I was wondering if there is a way to export all of the data in Access back into Excel so that it is formatted exactly the same way it was before it was exported into Access

    Sorry if this is a noobish question, I'm new to Access and don't have much experience with it yet.

    Thanks

    Login To add answer/comment
     

Share This Page