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

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 10 points N/A #170511

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

qa-featured

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.

Login/Register to Answer

Related Questions