I am in need to convert my spreadsheet tables to a fully formatted database system to access records through an online portal created for access. How can I convert Excel to access 2007?
To convert Excel to access is not possible, but there is a way of importing Excel spreadsheet to access and store the data in a sequential manner. For that, you need to follow the steps.
Step 1: Open Access and click on Fileïƒ Importïƒ From Excel spreadsheet.
Step 2: Once you have selected the data you can go through the procedure steps and select the dialog box one by one and click on next.
Step 3: On the final step click on the finish button.
Step 4: The Excel spreadsheet is now entered into the database.  
