Article ID: 275068 - View products that this article applies to.
This article was previously published under Q275068
Novice: Requires knowledge of the user interface on single-user computers.
This article applies to either a Microsoft Access database (.mdb) file or to a Microsoft Access database (.accdb) file, and to a Microsoft Access project (.adp) file.
The column format on a Microsoft Excel worksheet is lost or replaced with a different format after you import the data that is in the Excel worksheet into Microsoft Access or create a link to the Excel worksheet.
Microsoft Access does not maintain the format of an Excel column. When you import or create a link, formatting such as the British pound and the Euro symbol are lost. After the importing operation or the linking operation is completed, the data inherits the format of the regional settings that are specified in the operating system.
These settings are not lost when you import from or link to an HTML file. For an example of how to preserve the currency formats of an Excel worksheet, follow these steps:
Contact us for more help
Connect with Answer Desk for expert help.