The difficult I do immediately, the impossible takes a little bit longer.
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 all Import or Export File Specifications except Excel worksheets )
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
and click Save As… At this point you can either give it a new name or save,
overwriting the existing file name

1. Go to the External Data tab and select your Import file type...
Import Specifications...
How to use Windows System Colors   (Access 2003 and earlier)
Where are the Options?   (Access 2007 and higher)
Trusted Location   (Access 2007 and higher)
Export Specifications   (Access 2007 and higher)
Navigation Pane Options  (Access 2007 and higher)


Object Designers (Access 2007 and higher)

Set Subdatasheet to None (Access 2003 and higher)