Import Specs (1 Viewer)

[markcrobinson]

I frequently need to examine or edit the Saved Import Specs, but can't seem to find where these are stored.
Can this be done?

 

[isladogs]

They are in a hidden system table called MSysIMEXSpecs
There is another related system table called MSysIMEXColumns

Edit anything in there with care!

 

[arnelgp]

you can't do much with those tables.
try inspecting ImportExportSpecification object, especially its .xml property
where you find which external file is involved.

 

[isladogs]

you can't do much with those tables.
try inspecting ImportExportSpecification object, especially its .xml property
where you find which external file is involved.

arnel
Please could you explain for the benefit of all who do not have your higher level of knowledge:
1. what is in the xml object that can't be accessed from the 2 tables
2. how you inspect the xml ImportExportSpecification object

Thanks in advance