TransferSpreadsheet Macro Action

You can use the TransferSpreadsheet action to import or export data between the current Access database (.mdb or .accdb) or Access project (.adp) and a spreadsheet file. You can also link the data in a Microsoft Office Excel 2007 spreadsheet to the current Microsoft Office Access 2007 database. With a linked spreadsheet, you can view and edit the spreadsheet data with Access while still allowing complete access to the data from your Excel spreadsheet program. You can also link to data in a Lotus 1-2-3 spreadsheet file, but this data is read-only in Access. This action will not be allowed if the database is not trusted. This paper contains arguments on the TransferSpreadsheet macro action.