Microsoft KB Archive/886634

= 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 =

Article ID: 886634

Article Last Modified on 2/7/2007

-

APPLIES TO


 * Microsoft Office Access 2003
 * Microsoft Access 2002 Standard Edition
 * Microsoft Access 2000 Standard Edition

-



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.



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.



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.
 * 1) Click OK to close the Import Specification dialog box.
 * 2) Complete the remaining steps in the Import Text Wizard.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section.



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.

Keywords: kbtshoot kbexpertisebeginner KB886634

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.