Where can i backup Export Specifications?

R

Rodolfo Fontes

Hi group,

I've done this question inside other Subject, so that's why i've opened a
new one.

All the specifications that i've done on import/export settings, where are
they stored? Can I backup then? Copy to another machine?

Thanks,
Rodolfo Fontes
 
R

Rodolfo Fontes

Thanks Nikos!

Nikos Yannacopoulos said:
Rodolfo,

The Import/Export specs are stored in two system tables called
MSysIMEXSpecs and MSysIMEXColumns. You can see the tables (but Access will
not allow you to make changes to them!) by going Tools > Options in the
menu, and clicking on System Objects on the View tab.
One way to back them up / transfer them is by importing them in another
database; to do that, open the target database and go File > Get External
Data> Import. When you have selected the original database to import the
specs from and the Import Objects wizard opens, click on button Options
and tck Import/Export Specs.

HTH,
Nikos
Click to expand...
 
N

Nikos Yannacopoulos

Rodolfo,

The Import/Export specs are stored in two system tables called
MSysIMEXSpecs and MSysIMEXColumns. You can see the tables (but Access
will not allow you to make changes to them!) by going Tools > Options in
the menu, and clicking on System Objects on the View tab.
One way to back them up / transfer them is by importing them in another
database; to do that, open the target database and go File > Get
External Data> Import. When you have selected the original database to
import the specs from and the Import Objects wizard opens, click on
button Options and tck Import/Export Specs.

HTH,
Nikos
 
Top