Convert or Import Excel sheet to Access Database

One of our readers wanted to know how to convert the excel .xls spreadsheet into the MS Access .accdb file with all the tables remaining as it is in the Access file. If you also work between the two files and wanted to know the same procedure then here is way how it is done.

Steps:

1.    Create a new Access database file on your desktop or into a folder which will serve as the target file for us.

2.    Open this access file, go to the External Data tab and click Continue reading “Convert or Import Excel sheet to Access Database”