One of the most powerful features contained within the Microsoft Access database program is the ability to create import and export specifications. These specifications are important for a number of reasons, but one of the most powerful is that it allows for the importation and exportation of data to be automated and scheduled.
The import specifications for transferring text or other types of files to and from Access can be saved on the last page of the Import Text Wizard simply by checking the Save Import Steps check box. After that box has been checked, an additional set of controls will appear.
Saving the import specification is the key to automating imports from other files, and those scheduled tasks are handled through the Create Outlook Task check box. Simply check that box and click Save Import. Checking that box creates a task in Microsoft Office Outlook 2007, allowing the specification to be run at a specified future date and at set intervals.
When the Create Outlook Task option is chosen, Access will display the Import Name Task dialog box. Follow these steps to complete the process:
In order to run a saved task:
The ability to automate tasks has always been a powerful feature of Microsoft Access, and that power has been further enhanced within the newest version. Access 2007 makes it even easier and more user friendly to gather the data that is needed, no matter where that data resides or how often it changes.
Microsoft Access is an application used to create small and midsize computer desktop databases for the Microsoft Windows family of operating systems. It can also be used as a database server for a web-based application.
This electronic book (ebook) provides lessons on how to use Microsoft Office Access 2007 to create and manage databases. The lessons follow a step-by-step format with practical examples.
Download the ebook now - Microsoft Office Access 2007 Desktop Databases