where are import specifications saved?

[martin]

I am doing a transfertext command with an import
specification file. Where is it saved? How do i give it to
other users?

Thanks
Martin

 

[Immanuel Sibero]

Hi Martin

Hidden/System table: MSysIMEXSpecs


You can import these specs by:

File>>Get External Data>>Import
After you select an Access file to import from, a window "Import Objects"
will appear.
Click on Options to specify that you want to import *Import/Export
Specifications* <G>


HTH,
Immanuel Sibero

 

[Ronald W. Roberts]

Under Tools/Options, look at the tab "View". Under "Show", check the
System Objects. This will unhide all of the system tables in Access.
The specification information is in the MSysIMEXSpecs table.

Not sure there is a good way to copy this table because Access may use
other system tables in addition to this table for import/export information.
You may have to create the table using the wizard for each user.

If your application is setup with a front-end and a back-end, then just
give
your users a new copy of the front-end and the import spec will be there.

Ron