Import or link a delimited or fixed-width text file

Import or link a delimited or fixed-width text file

Note   You can link a table only in a Microsoft Access database, not a Microsoft Access project.

Important   Before you import or link data from a delimited text file or fixed-width text file, make sure that the file has the same type of data in each field and the same fields in every row.

  1. Open a database, or switch to the Database window for the open database.

  2. To import data, on the File menu, point to Get External Data, and then click Import.

    To link data, on the File menu, point to Get External Data, and then click Link Tables.

  3. In the Import (or Link) dialog box, in the Files Of Type box, select Text Files (*.txt;*.csv;*.tab;*.asc).

  4. Click the arrow to the right of the Look In box, select the drive and folder where the file is located, and then double-click its icon.

    Important   If you link to a file on a local area network, make sure that you use a universal naming convention (UNC) path, instead of relying on the drive letter of a mapped network drive in Windows Explorer. A drive letter can vary on a computer, or it may not always be defined; whereas, a UNC path is a reliable and consistent way for Microsoft Access to locate the data source that contains the linked table.

  5. Follow the directions in the Import Text Wizard dialog boxes. Click Advanced to create or use an import/export specification.

Notes