Regina Whipp

The difficult I do immediately, the impossible takes a little bit longer.

Miscellaneous

Access Options—Import Specifications

1.  Go to the External Data tab and select your Import file type...

2.  Navigate using the Browse button to the file you want to Import and...

3.  Continue to follow the steps...

4.  Clicking the Advanced button brings up the Import Specification window where you can change the Field Name, Data Type, Indexing and/or choose to Skip a field.  Once complete Save your Import Specification and give it a coherent name...

5.  If your are going to repeat this Import you should save these steps for use with the acImport function. Should you want to modify your Specification file…

 

(Will work for Import or Export File Specifications)

           Follow Step 1 (selecting any file as you will not be importing it) thru Step 3

           Then click the Advanced button and select the Specification file you want to modify

           Modify and click Save As…  At this point you can either give it a new name or save

             overwriting the existing file name.