Hi.

You can use the Import/Export wizard, which utilizes the info in the
MSysIMEXSpecs and MSysIMEXColumns tables, to view the information in a more
organized format.

To do so, open your database and select the table you would export (such as
"MyTable") in the database window.  On the "File" menu, select "Export" to
open the "Export Table 'MyTable' As" dialog window.  In the "Save as type:"
combo box, select "Text files:  (*.txt, *.csv, *.tab, *.asc)," and then click
the "Save" button.

The Export Text Wizard window pops up.  In the bottom left corner, select
the "Advanced..." button.

The "Export Specification" window pops up.  On the right hand side of the
window, select the "Specs..." button.

The "Import/Export Specifications" window pops up.  Select your "Spec name"
specification from the list box and then click on the "Open" button.  Your
file format info and field info for this particular specification will be
displayed for you, including field delimiters, date formats, and field names.

When you are finished viewing the information, hit the cancel buttons on the
"Export Specification" and  Export Text Wizard windows, so that you don't
actually export what might be a very large table.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question, please sign in to Microsoft's
Online Community and mark these posts, so that all may benefit by filtering
on "Answered questions" and quickly finding the right answers to similar
questions.