MS Access Export To CSV

Ms Access Export To Csv – This tutorial will cover topic how to export ms access database to excel csv file. CSV is a simple file format used to store tabular data, such as a spreadsheet or database. It can be used to exported and imported to other program such as Ms Excel, SQL, and other database program. Other advantage of CSV format is the small size that perfect for emailing.

To export the database to CSV format, follow this instruction.

Open the Access file to be exported.

Click on the table or query to export from.

Navigate to External Data tab > Export group > Export to Text File.

Ms Access Export To Csv-1

4. An Export Wizard dialog box will appear. Choose a location for the exported CSV. If you need to change the file name, make sure that the new file name ends with .csv extension). Optionally, you can select the options to “Export data with formatting and layout.”

Ms Access Export To Csv-2

5. Next, choose one of the 2 export formats:

Delimited: using comma or tab to separate each field

Fixed Width: Fields are aligned in columns with spaces between each field, give it neater look.

NOTE: Delimited is more recommended because it fit the most with other program.