Export a table to a text file pipes delimited

  • Thread starter Thread starter Sally
  • Start date Start date
S

Sally

I need to export an access table to a text file but it
needs to be pipes delimited, Does anybody know how to do
this?
 
Sally,

The first thing you need to do is create and save an Export Specification:
In the Database Window, highlight the table. Then, from the Access Menu,
click File|Export and select Text File from the "Save as Type" combo box.
Click the "Export" button.

This will open the Export Wizard window. Look in the lower left corner of
the window for the "Advanced" button and click it. When the Export
Specification window opens, look for the Combo box labeled "Field
Delimiter". Simply type a pipe symbol into it. You can then click the
"Save as" button and name your specification for later use.
 
Back
Top