How to import Excel into Access with the help of steps?

Asked By S.Jabeen 0 points N/A Posted on - 08/20/2016

I very often need to use Excel. I want to work with the data now using Access. I want to copy the data into database. How to import Excel into Access?

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

• Answer Accepted: No
• Question Category: MS Excel

Answered By Goatham Chan 10 points N/A #170511

How to import Excel into Access with the help of steps?

You may want to import Excel into Access to use the data management. It is a secure way of working. When you save data in Access then there is no altering of data in Excel. These are the following steps to copy Excel data into Access.

Step 1: Open the workshert in Excel.

Step 2: Choose the rows that you want to copy.

Step 3: Select Copy in the Clipboard.

Step 4: For copying, you can also use the command CTRL+C.

Step 5: Open the table query in Access and paste the rows.

Step 6: Click Datasheet tab and then View and then Datasheet View.

Step 7: Paste the data using CTRL+V.

Step 8: In Edit menu select Paste Append.

About Goatham Chan

Questions
31

Answers
23

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/20/2016
• Question Category: MS Excel