Key Terms
Delimiter - a text character that will separate the data fields in your export file. (ie. 35; Pitt St; Sydney)
Qualifier - a text character used on both sides of data strings to encapsulate the entire string. (ie. "Bush, George"). This is used in the case when your data may contain the Delimiter character but needs to be read as a single field.
Microsoft Access 97/2000
  1. Run Microsoft Access and open your database.
  2. Select the Tables (or Queries) tab, and choose the Table (or Query) containing your data.
  3. On your toolbar (top of screen), select File --> Export.
  4. A new window will appear. Choose the directory you want your file saved.
  5. From the Save as type drop-down list, select Text Files (*.txt;*.csv;*.tab;*.asc).
  6. Enter an appropriate name for your file (with the extension .txt) and click Export.
  7. In the next screen, select the Delimited export format and click Next >.
  8. Now, choose the Tab delimiter (or any other delimiter of your preference).
  9. Tick the Include Field Names on First Row checkbox and select {none} as the Text Qualifier (unless otherwise required).
  10. Click Next > to proceed to the next screen, and Finish to confirm the name and location of the export file.
Microsoft Excel 97/2000
  1. Run Microsoft Excel and open your spreadsheet.
  2. On your toolbar (top of screen), select File --> Save As...
  3. A new window will appear. Choose the directory you want your file saved.
  4. From the Save as type drop-down list, select Text (Tab Delimited) (*.txt).
  5. Enter the name of the export file and click on Save.
Microsoft SQL Server 2000
  1. Run SQL Server Enterprise Manager and open your database.
  2. Select the Table you want to export, right-click on it, go to All Tasks --> Export Data...
  3. The Export wizard will start up, click Next > to continue.
  4. You are now at the Source configuration window. Confirm that everything in this screen is correct (which it should be by default) and click Next >.
  5. You are now at the Destination configuration window. Select Text File from the Destination drop-down list.
  6. Now enter the path and filename for your export file in the text field below and click Next >.
  7. Select the Copy Table(s) and View(s)... option and click Next >.
  8. In the next screen, select Tab as your Column Delimiter and <none> for Text Qualifier.
  9. Tick First row has column names and click Next >.
  10. On the next screen click Next > to run export immediately, and Finish on the confirmation screen.
Microsoft Word
  1. If your data is stored in a table-like format, highlight all the columns using your mouse.
  2. Copy the data into your clipboard (CTRL+C), or Edit --> Copy.
  3. Open up Excel and paste the data in there (CTRL+V), or Edit --> Paste.
  4. Now follow the instructions for Microsoft Excel (above) to export into a text-delimited format.
FileMaker Pro 4/5/6
  1. Open your FileMaker database.
  2. Go to File --> Export Records...
  3. Type in a filename and select Tab-Separated Text Files (*.tab) from the Save as type list. Click Save.
  4. A new window will pop up asking you which fields you would like to export. Click on Move All to export every field.
  5. Select the Windows (ANSI) character set, and choose the Don't format output option.
  6. Click on Export to finish.
Terms of Use | Privacy Policy
©2009 Intech Solutions Pty. Ltd. All Rights Reserved.