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?
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.
