File Spec Question

[RJ]

I have a saved file spec which needs to be updated periodically. Is there a
way to automate the updating of the file spec? (ie refer it to a saved table
or excel worksheet)

Background: This saved file spec is referred to during an automated daily
table linking routine run each morning. When the file spec needs to be
updated I can manually link a table and save the new file spec over the
existing one.

 

[John Nurick]

Rather than use import/export specifications I'd probably do this by
writing code to create a new schema.ini file each time things changed.

Alternatively - since the specifications are stored in the hidden
system tables MSysIMEXSpecs and MSysIMEXColumns - it's possible to use
queries to modify them, although AFAIK this is neither documented nor
supported.