Excel delete blank rows and blank cells before import into Access

Posted on December 15, 2015 by Wyman W

This Access tutorial explains how to delete blank rows and blank cells in Excel before import into Access. You may also want to read: Excel Delete Blank Rows Import Chinese CSV to Excel Import Excel File into Access When you import an Excel file into Access, you may come up with several issues regarding Excel blank cells. Excel blank cells are not considered as Null value in Access Excel blank rows after the last record are also imported Excel blank columns after the last column a...

Set password for Access database to protect back end database

Posted on April 8, 2015April 8, 2015 by Wyman W

This Access tutorial explains how to set password for Access database to protect back end database. You may also want to read: Access user login Form and verify password Set password for Access database to protect back end database If you are making an Access application for multiple users, it is a good practice to create a front end application and back end database. You should store all tables /Modules in back end and lock it with password. For front end, create user forms / query...