Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. You cannot import the data from a comma-delimited text file by using the Import Text Wizard in Office Access 2003, in Access 2002, or in Access 2000

You cannot import the data from a comma-delimited text file by using the Import Text Wizard in Office Access 2003, in Access 2002, or in Access 2000

Symptoms

You cannot import the data from a comma-delimited (.csv) text file by using the Import Text Wizard in Microsoft Office Access 2003, in Microsoft Access 2002, or in Access 2000. When you try to import data, the columns are not imported. This issue occurs if the top 25 rows of the data contain no values.

↑ Back to the top

Cause

When you start the Import Text Wizard, the wizard reads the first 25 rows from the top of the data, and then determines which columns of data to import. If the wizard finds no values in the first 25 rows, the wizard treats the columns as if they contain no data.

↑ Back to the top

Resolution

To resolve this issue, use one of the following methods.

Method 1

Before you import the .csv file, type the field name in the top row of each column, and then save the file.

Method 2

Manually import the data. To do this, follow these steps:
  1. Open the Access database into which you want to import the data.
  2. On the File menu, point to Get External Data, and then click Import.
  3. In the Import dialog box, select Text Files (*.txt; *.csv; *.tab; *.asc) in the Files of Type list, and then click the name of the file that you want to import.
  4. Click Import to start the Import Text Wizard.
  5. Click Advanced. The Import Specification dialog box appears.

    Note You can create and then save a new import specification. You can also use an existing import specification that has specifies all the correct fields.
  6. Click OK to close the Import Specification dialog box.
  7. Complete the remaining steps in the Import Text Wizard.

↑ Back to the top

Status

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

More Information

Steps to reproduce the issue

  1. Create a .csv file that contains three columns and 30 rows.
  2. Delete the data in all three columns for the first 25 rows, and then save the file.
  3. Start Access.
  4. On the File menu, point to Get External Data, and then click Import.
  5. In the Import dialog box, select Text Files (*.txt; *.csv; *.tab; *.asc) in the Files of Type list.
  6. Import the .csv file that you saved in step 2.
Notice that the data in rows 26 through 30 is not imported into Access.

↑ Back to the top

Keywords: kbharmony, kbtshoot, kbexpertisebeginner, kb, kbarchive

↑ Back to the top

Article Info
Article ID : 886634
Revision : 3
Created on : 4/17/2018
Published on : 4/19/2018
Exists online : False
Views : 180