Creating a Text File with Microsoft Access

---

To create a tab-delimited text file from a Microsoft Access database, follow these steps:

1. Using Access functionality, arrange your data as defined above in a single Table. Field names and order must exactly match the definitions above. Each row in the table is an individual record.

   Note: An Access template for capital and expensed equipment is available from PartBridge's Upload page. Look for this link:

   

   If you see an "Enter Network Password" box when trying to download the template, click Cancel until the file opens in your browser.

2. Enter data in all the columns for which there is a value. If a field is not required and there is no value, leave the column blank for that row. In other words, the header must be present even though the value is blank.
3. Select File --> Export --> To an External File or Database.
4. Choose Save as Type --> Text Files.
5. Choose Delimited, then click Next.
6. Choose Tab.
7. Check Include Field Names on First Row, select {none} for Text Qualifier, then click Next.
8. Select Export to File, then click Finish.

Related topics:

• Creating a Text File
• Uploading Capital and Expensed Equipment Data
• Adding a Single Sell Posting
• Adding a Single Buy Posting
• Creating a Text File with Microsoft Excel