Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
You cannot format data imported from Access 2002 to Excel 2000 or to Excel 97
Article ID: 818082 - View products that this article applies to.
After you use Microsoft Office links to export data from Microsoft Access 2002 and open the file in Microsoft Excel 2000 or in Microsoft Excel 97, you cannot bring up the Format Cells... dialog box. When you right-click a cell and select Format Cells... (or click Cells on the Format menu), the Format Cells... dialog box does not appear, and you do not receive an error message.
If you copy and paste data from Access 2002 to Excel 2000 or to Excel 97, the same behavior occurs.
To work around this problem, do one of the following:
Microsoft has confirmed that this is a problem in Microsoft Access 2002.