Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Adding a field to Import Specs

79 views
Skip to first unread message

Carmalita

unread,
Jan 16, 2003, 8:55:41 AM1/16/03
to
How can I add/insert a new field to an existing Import
specification? <file/get external data/import>


Joe Fallon

unread,
Jan 18, 2003, 5:41:30 PM1/18/03
to
To my knowledge, you can't insert a column into the middle of an existing
spec. You should be able to add one to the end though.

If that is not acceptable, you have a few options.
1. Re-write the spec.

2. Manipulate the hidden system tables.
Tools, Options, View
Hidden Objects
System Objects

This is undocumeted/unsupported.

The table you want is: MSysIMEXColumns.
But if you edit the table you find it is locked!

A little known trick is to write a query against the table.
The query is updateable!

SELECT MSysIMEXColumns.Attributes, MSysIMEXColumns.DataType,
MSysIMEXColumns.FieldName, MSysIMEXColumns.IndexType,
MSysIMEXColumns.SkipColumn, MSysIMEXColumns.SpecID, MSysIMEXColumns.Start,
MSysIMEXColumns.Width
FROM MSysIMEXColumns;

--
Joe Fallon
Access MVP

"Carmalita" <csgr...@aol.com> wrote in message
news:6e6601c2bd66$f4ebe790$89f82ecf@TK2MSFTNGXA01...

Rick Brandt

unread,
Jan 18, 2003, 5:56:24 PM1/18/03
to
"Joe Fallon" <jfal...@nospamtwcny.rr.com> wrote in message
news:e6GEtK0vCHA.2372@TK2MSFTNGP12...

> To my knowledge, you can't insert a column into the middle of an existing
> spec. You should be able to add one to the end though.
>

You can cut all rows from the spec below where you want to add the new row
to the clipboard, add your new row(s) and then paste the clipped rows back
underneath the new ones.


Joe Fallon

unread,
Jan 19, 2003, 12:10:05 AM1/19/03
to
Cool!
Nice work around.

--
Joe Fallon
Access MVP

"Rick Brandt" <rvtjb...@sbcglobal.net> wrote in message
news:b0cm2i$nv6m2$1...@ID-98015.news.dfncis.de...

0 new messages