How Can I Convert Excel To Access 2007?

Asked By 10 points N/A Posted on -

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?

Answered By 55 points N/A #169548

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.  

Login/Register to Answer

Related Questions