Import Specification

[Bob]

Is there a way to copy an import specification from one pc
to another?

Thanks,
Bob

 

[Rick Brandt]

Is there a way to copy an import specification from one pc
to another?

They can be imported, but in their infinite wisdom MS decided to hide that
fact unless you press the [Options] button on the import wizard form. You
also can't pick and choose. It's all or nothing.

 

[Bob]

I don't see an "Options" button. I have Advanced where
you set up the import specification, but I don't see
Options anywhere.

Thanks for the help!

-----Original Message-----

Is there a way to copy an import specification from one pc
to another?

They can be imported, but in their infinite wisdom MS decided to hide that
fact unless you press the [Options] button on the import wizard form. You
also can't pick and choose. It's all or nothing.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.

 

[Rick Brandt]

I don't see an "Options" button. I have Advanced where
you set up the import specification, but I don't see
Options anywhere.

Thanks for the help!

From the file you want to import into...

File - Get External Data - Import
Select file to import from
Resulting dialog has an [Options>>] button in the lower right.
In the lower left of the expanded dialog is option for Import/Export Specs

The above is accurate for Access 97 and Access 2000. I don't know if it
has changed in newer versions.