how to retrieve items from MSysIMEXSpecs? 1

[barny2006]

remou,
i mean, as pete said, if i want to retrieve and save import specs in a file or something, how could i iterate through the msysimexspecs? can i do a select from msysimexspecs? and if i do, what fields/columns are in that object? can you give an example?
like this one?
SELECT MSysObjects.Name FROM MsysObjects " & _
"ORDER BY MSysObjects.Name;"
this will list all the objects' names, tables, queries, reports, modules, forms, etc. one of which is msysimexspecs. then i use this code to list the name of the object:
obj_name = objRecordset.Fields.Item("name")
which lists the name of objects.
in case of msysimexspecs, what field items are available?

 

[Remou]

Go to Tools->Options and tick System Objects on the view tab. You will find two tables that relate to specifications, MSysIMEXSpecs and MSysIMEXColumns. You can examine the table structure. Meddling with system tables can seriously damage the health of your database.

 

[barny2006]

thanks so much, remou.
i found it ok.