Microsoft KB Archive/875252

= You cannot rename or modify a field in the Import Wizard when you try to import data from a text file or from an Excel worksheet into Access 2002 =

Article ID: 875252

Article Last Modified on 7/29/2004

-

APPLIES TO


 * Microsoft Access 2002 Service Pack 3 (SP3)

-





SYMPTOMS
When you try to import data from a text file or from a Microsoft Excel worksheet into Microsoft Access 2002, you cannot rename or modify a field in the Import Wizard.



CAUSE
This problem occurs after you install Microsoft Office XP Service Pack 3 (SP3).



How to obtain the hotfix
This issue is fixed in the Microsoft Access 2002 post-Service Pack 3 Hotfix Package. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

841365 Description of the Access 2002 post-Service Pack 3 hotfix package: May 27, 2004



WORKAROUND
To work around this problem, use one of the following methods:
 * Rename the field names by using the Advance import file settings if the source is a text file.
 * Rename the field names in Microsoft Excel if the source is an Excel worksheet.

Import data from a text file

 * 1) Start Access 2002, and then open your database.
 * 2) On the File menu, click Get External Data, and then click Import.
 * 3) In the Import dialog box, select Text Files (*.txt;*.cvs;*.tab;*.acs) for the Files of type.
 * 4) Select the text file that you want to import, and then click Import.
 * 5) Click Delimited or click Fix Width, and then click Advanced.
 * 6) In the Field Information table, type the new field names that you want to rename, and then click OK.
 * 7) Follow the remaining steps that appear in the Import Text Wizard.

Import data from an Excel worksheet
When you import data from an Excel worksheet, rename the field names in Excel to the field names that you want in Access 2002, and then import the data from the Excel worksheet into Access 2002 with the correct field names.

To do this, follow these steps:
 * 1) Start Access 2002, and then open your database.
 * 2) On the File menu, click Get External Data, and then click Import.
 * 3) In the Import dialog box, select Microsoft Excel (*.xls) for the Files of type.
 * 4) Select the Excel worksheet that you want to import, and then click Import
 * 5) Follow the remaining steps that appear in the Import Spreadsheet Wizard.



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



MORE INFORMATION
For additional information about Microsoft Office XP Service Pack 3, click the following article number to view the article in the Microsoft Knowledge Base:

832671 Description of Microsoft Office XP Service Pack 3

For additional information about the terminology that Microsoft uses when correcting software after it is released, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

Additional query words: Import Wizard Rename

Keywords: kbfix kbqfe kbprb KB875252

-

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

© Microsoft Corporation. All rights reserved.