RunSavedImportExport Macro - How Can You Edit Definition?

[Skittle]

I have inherited an Access database used to manipulate data from a supplier and import it into a database.
The Access database use a Macro that performs a RunSavedImportExport step followed by two ImportExportText steps.

The RunSavedImportExport step just seems to have a parameter of a definition name.
How can I view/edit the definition name?

Where is the definition stored? It just seems to be a named 'thing' but I can't find it in a folder outside of Access or as an object within Access?



Dazed and confused.

Remember.. 'Depression is just anger without enthusiasum'.

 

[dhookom]

I don't understand why you would want to edit the definition name. However, the imp/exp specifications are store in two system tables: MSysIMEXSpecs and MSysIMEXColumns. The SpecID is the primary/foreign key.

I think you can edit the data if you create a query of the table(s).


Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016