HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Microsoft Access Export to Excel

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
accessmicrosoftexcelexport

Problem

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

Solution

To export all the tables on Linux try this command:

mdb-tables -d ',' database.mdb | xargs -L1 -d',' -I{} bash -c 'mdb-export database.mdb "$1" >"$1".csv' -- {}


You can use mdbtools also into windows via WSL (Ubuntu on Windows or Debian on Windows):
Then install it in console with:

sudo apt install mdbtools

Code Snippets

mdb-tables -d ',' database.mdb | xargs -L1 -d',' -I{} bash -c 'mdb-export database.mdb "$1" >"$1".csv' -- {}
sudo apt install mdbtools

Context

StackExchange Database Administrators Q#105909, answer score: 2

Revisions (0)

No revisions yet.