Change export specifications

[Guest]

I found a table called MSysIMEXColumns that holds the data for my
specifications. I need to add a new record and it will not let me. Is this
a setting that I can change?

I need to change the specification because I've had to add a new field to my
transfertext export I guess I have to add the new field to this
MSysIMEXColumns table to be able to do that. If I'm incorrect please someone
tell me a way to do this.
thanks

 

[David Lloyd]

Glenda:

You can add a column to the MSysIMEXColumns table using an Append query.
This assumes you have the appropriate permissions on the table. You can
check permissions by using the Tools menu > Security > User and Group
Permissions.

That being said, the easier way to do this is to view the saved export
specification. Go to File > Export... and in the "Save as type" combobox,
select Text Files and click Export. This will start the export wizard.
Selected the Advanced button and then Specs button to view your saved
specification names. Selected your export specification and click Open.
You can then edit the columns in the specification.

As a side note, the MSysIMEXColumns works together with the MSysIMEXSpecs
table, to save all of the specification information.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I found a table called MSysIMEXColumns that holds the data for my
specifications. I need to add a new record and it will not let me. Is this
a setting that I can change?

I need to change the specification because I've had to add a new field to my
transfertext export I guess I have to add the new field to this
MSysIMEXColumns table to be able to do that. If I'm incorrect please
someone
tell me a way to do this.
thanks

 

[Guest]

Thank you very much!