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 (875252)



The information in this article 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).

RESOLUTION

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 "Applies to" 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


Modification Type:MajorLast Reviewed:7/29/2004
Keywords:kbprb kbQFE kbfix KB875252 kbAudITPRO kbAudEndUser