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

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.

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:

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.

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

For additional information about Microsoft Office XP Service Pack 3, click the following article number to view the article in the Microsoft Knowledge Base:
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: