Exporting Data from Access Database into .csv File

Question

My company is planning to migrate from our current database (MS Access) to a new one. I'm being asked by our consulting firm to provide them with a .csv file containing all of the existing data. My question is... is there a way to export all of the existing data from an Access database into a single .csv file? We're currently running MS Office 2007, if that matters.

Any guidance you can offer will be greatly appreciated. Thanks in advance for your assistance!

Best regards,

John

Patrick Honorez · Accepted Answer · 2015-07-01 17:56:52Z

1

Of course no. You can export to 1 csv per table.

answered Jul 1, 2015 at 17:56

Patrick Honorez

25.4k12 gold badges97 silver badges163 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Martijn van der Jagt · Accepted Answer · 2015-07-01 22:28:58Z

0

The definition of a .CSV file is that all columns contain the same type of information, and the header (optionally) contains the title of the column. So in this concept you can not share multiple tables.

You could concat all the files into one, but no other application would be able to read your construct.

You can however transport a collection of .csv files in one .zip file if you like. Or you can export all tables (one tab per table) in an MS-Excel file.

answered Jul 1, 2015 at 22:28

Martijn van der Jagt

5143 silver badges13 bronze badges

Collectives™ on Stack Overflow

Exporting Data from Access Database into .csv File

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related