Things You'll Need:
-
Step 1
Open your database file in Microsoft Access.
-
Step 2
Use the F11 key to open the Database window.
-
Step 3
Click on the Table tab. A listing of your tables appears.
-
Step 4
Select the table you want to work with and click Open.
-
Step 5
Open the application that contains the data you want to bring in. Be sure the data is in a format that Access can use. If the information is in a word processor, it must be formatted in a table or else each "field" must be separated by tabs.
-
Step 6
Ensure that the order of the columns in the data to be pasted matches the order of fields in your database table.
-
Step 7
Select the rows you want to copy, then select Copy from the Edit menu.
-
Step 8
Going back to Access, decide whether you want to replace old records with the new ones, or whether you want to add the new records at the end of the data sheet.
-
Step 9
To replace, select the records to be replaced, then click Paste from the Edit menu. The records replace the ones you selected.
-
Step 10
To paste the records at the end of the data sheet, go to the Edit menu and click Paste Append. The records will appear at the bottom of the sheet.
-
Step 1
Realize that data can be imported directly into a table only if the external application is a spreadsheet or text file.
-
Step 2
Open the Database window.
-
Step 3
From the File menu, select Get External Data, then Import.
-
Step 4
Move through your folders until you locate the file containing the data you want to import.
-
Step 5
Select the file, then click Import.
-
Step 6
An Import wizard appears. Use the wizard to import your data. When asked, select the table that you want to receive the new data.
