Reader Level:
Articles

Export Text File in Access 2013

By Richa Garg on July 31, 2012
In this article I explain how to export or read the text file in Access 2013.
  • 0
  • 0
  • 3629

In order to export a text file in Access 2013, use the following steps.

 Step 1 : First open the Access 2013 and select the blank database; then give the name of the database that you want to give and click on create.

pic1.gif

 Step 2 :  Now go to the External Data menu to select the external files. Now in this select text File.

  pic2.gif

 Step 3 : When we click on the Text File a window appears, here in order to select the text file click on the browse button.

pic3.gif

 Step 4 : A window appears; in it, select your text file that you want to export.

  pic4.gif

 Step 5 : After that your file is selected the window will appear with the content of text file, like:

  pic5.gif

 Step 6 : Click next and next then save your text file in any table name. Now your file appears at the right-hand side inside the table that you specified at the time of exporting it.

pic6.gif

 Step 7 : Now click on the table in order to read the data of text file in the Access 2013.

pic7.gif

 Step 8 : Now in this file we can also edit the content, delete the content and insert new data into it. I made changes in this file like:

pic8.gif

 Step 9 : Save the file and use it.
 

Richa Garg

I am a Junior Software Developer In MCN Solutions Pvt. ltd. and very much interested in .net technology : Asp.net, C#, WPF,  SQL Server, Windows Store apps, HTML, DHTML, CSS etc......

COMMENT USING

Trending up