Administrator: Rave Reviews (Start) 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

Import from Excel

Save Import Specifications

Repetitive tasks just beg for a method to automate the steps. If you will be importing the information again and again, you can save the Import Steps.

 

Create a Task in Outlook

Microsoft Access can also create a Task in Outlook to remind you to run the import. Now that's office productivity, right there. <grin>

External Data-> Import ->Excel
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 3. Entering and Modifying Data 

  3.5. Import data  3.5.3.   Save and run import specifications