How Can I Convert Excel To Access 2007?

Asked By Eaan Rickchard 10 points N/A Posted on - 09/13/2016

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?

• Status: Open
• Question Views: 453
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Qamar Khan 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.  

About Qamar Khan

Questions
5

Answers
27

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 09/13/2016
• Question Category: MS Access