I want to import an Excel file with client information into an MS Access database, but some data were not entered properly as some are in caps or it does start with a capital letter. Is it possible to format cells automatically in such a way that “LONDON”, for example, becomes “London”?
Hello Beverly,
You can use Mask Wizard in MS Access for a lot of formatting features that you want. I suggest you to download the Mask Wizard and follow the instructions:
You can also try the following steps:
-Zorian
Yes, there is a solution for import Excel file into an MS Access database. For solving this problem you need to use the Mask Wizard for importing Excel file into the MS Access database.
After installing this, please follow these instructions step by step:
1. Choose design view from view menu.
2. Right-click the field you want to modify.
3. Click on Properties from the pop-up menu.
4. Click on the Data tab.
5. Now click on the Input Mask text box and then select a mask to continue.
6. You may make modifications if necessary. Then click next to save the sheet.
Thanks
