One of the most useful features of Microsoft Access for business users is its ability to integrate with other types of files. Microsoft Access can accept files in a wide variety of formats, including Excel spreadsheets, text files and mainframe documents. Users can make it even easier to import those files by setting up a macro that will do the work automatically. Once the macro is created, all the end user has to do is press a few buttons to import the data from the specified Excel spreadsheet.
- Skill level:
Other People Are Reading
Log on to your computer and open the Microsoft Access database. Click on the "Macros" tab.
Click "New" to create a new macro. Click the drop-down box under "Action" and choose the "Transfer Spreadsheet" option.
Change the transfer type to "Import" and type the file name, including the full path. For instance, if your spreadsheet is on your C drive in the spreadsheets folder, you would need to type "C:\Spreadsheets\MySpreadsheet.xls."
Click "Yes" or "No" in the "Has Field Names" box. Choose "Yes" if the first row in the spreadsheet contains the field names, otherwise click "No."
Click on the red X in the upper right-hand corner of the screen and answer "Yes" when prompted to save the macro. Give the macro a descriptive name.
Go to the "Macros" tab and double-click the macro to run it and import the spreadsheet. You can also right-click the macro and choose "Run" from the menu.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for