Import Specification

[Dennis Vipond]

I have several Access DB's in 2000 and 2002 format with Import
Specifications for importing from Text files. I would like to get these
scheme's out of Access for documentation purposes. Is there a way of doing
this?

Thanks in advance

Dennis

 

[Mike Labosh]

I have several Access DB's in 2000 and 2002 format with Import

Specifications for importing from Text files. I would like to get these
scheme's out of Access for documentation purposes. Is there a way of doing
this?

Import AND Export specifications are all stored in two hidden/system tables.

Goto Tools -> Options -> View

And check the two checkboxes for hidden tables & system tables. Then click
ok.

You can then write queries against them, make reports that use them, or just
simply export, MSysImexSpecs and MSysImexColumns

WARNING: Making Modifications to these (or any hidden/system table) can
make your database unusable or even unrepairable.

--
Peace & happy computing,

Mike Labosh, MCSD

"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane