Export Specification?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have just inherited a database and am converting it to SQL Server. There is
one place where a Table is exported to a file. In the code it does a

DoCmd.TransferText, acExportFixed, "Spec name", tablename, filename

I would like to know what the "Spec name" contains. Is there some way I can
open it to see what it does? I can look at it in the hidden msys table, but
that is ugly. Is there an easier way?

Thanks in advance,
 
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
 
Back
Top