Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 886634 - Last Review: February 7, 2007 - Revision: 1.3
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
On This Page
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:
- Open the Access database into which you want to import the data.
- On the File menu, point to Get External Data, and then click Import.
- 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.
- Click Import to start the Import Text Wizard.
- 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. - Click OK to close the Import Specification dialog box.
- 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 "Applies to" section.
MORE INFORMATION
Steps to reproduce the issue
- Create a .csv file that contains three columns and 30 rows.
- Delete the data in all three columns for the first 25 rows, and then save the file.
- Start Access.
- On the File menu, point to Get External Data, and then click Import.
- In the Import dialog box, select Text Files (*.txt; *.csv; *.tab; *.asc) in the Files of Type list.
- Import the .csv file that you saved in step 2.
Notice that the data in rows 26 through 30 is not imported into Access.
APPLIES TO
- Microsoft Office Access 2003
- Microsoft Access 2002 Standard Edition
- Microsoft Access 2000 Standard Edition
| kbtshoot kbexpertisebeginner KB886634 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please