Export Table To Plain Text In Access 2010

RDBMS (Relational Database Management System) are not abound, therefore, when sharing Access 2010 content with someone, you need to confirm if it is installed on the other end. For covering this up, Access 2010 provides an easy way to export database table into plain text file. Thus, you can easily exchange and share a text file which doesn’t require any specific compiler/encoder to open it.

To begin, launch Access 2010 and open the database table which you want to export into plain text file.

Navigate to External Data tab and click Text File.

external Export Table To Plain Text In Access 2010

It will bring up Export- Text File dialog, enter folder path where you want to export database table. From Export Options, enable Export data with formatting and layout option. If you want to immediately open the exported text file, enable Open the destination file after the export operation is complete option. Click OK to proceed further.


Choose an Encoding format from the list of options available; Windows (default), MS-DOS, Unicode, Unicode (UTF-8). Click OK to continue.


For saving export steps, enable Save export steps option and click Close.

remember steps

Before exchanging text file, open it to verify the field/row positioning and for any other discrepancy.

customer text

You can also check out previously reviewed guides on How to create tables in Access 2010 using only SQL commands & How to encrypt database with password in Access 2010

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *