Solved: Schema/Spec

[Oorang]

I have long noticed that maintains it's own list of schema as "specs" at the database level when you import text files. Is it possible to copy a spec from one db to another?

[stanl]

I have long noticed that maintains

I assume that between that....maintains you mean 'Access'? As a longtime user of Schema.ini entries I have asked a similar question many times. However, as of Office 2003 you have the .xsd format available which is more robust. I am just now looking into transferring Access xsd specs back and forth with SQL Server, and ISAMS, like Excel and Text.

I made a couple of posts re:xsd on the SQL forum regarding xsd and they died quickly.

If this has anything to do with your question (or it is just too early in the morning for me to be thinking straight) look into Application.ImportXML and Application.ExportXML

Stan

[alimcpill]

Also, I think if you open an mdb and do File->Get External Data->Import... then browse to the mdb containing the specs, in the Import Objects dialog you can expand the 'Options >>' button and on the left there's a checkbox 'Import/Export Specs' which is not selected by default. This should bring the file specs across from an existing database.

[XLGibbs]

the specs are in a hidden system table. Once you unhide that object (you can show hidden object from database tools/options menu), you can pretty easily figure out how to get it into another table.

[Oorang]

Huh, thought I checked those. Guess I didn't, cause there it all is in MSysIMEXSpecs & MSysIMEXColumns. Thanks! :)