How to Create a Macro in Access to Import Data
- 1). Open the Microsoft Access program and open a new table.
- 2). Click the tab on the menu bar and scroll to "New Object." Select "Macro" and then click "New."
- 3). Open up the "Action" menu by scrolling to and clicking the arrow in the "Action" column. Choose which action the Macro is to perform.
- 4). Choose a name for the macro action and type this name in the information window that is opened. Instructions for assigning Macro commands appears in the right-hand side of the pane.
- 5). Open up the application containing data you want to import to Access. Select the rows you want to copy, highlight, right-click and scroll to "Copy" and click.
- 6). Go back to the Access tab to paste data into the macro. Right-click and scroll down to "Paste" to transport data.
- 7). Click the "X" on the right-hand side of the macro box once the data has transferred. Click "Yes" to save the macro you created.
Source...