You could try using SQL Select. This will allow you to specify which columns you want/need in the new table.
If this doesn't work, I could send you a mapbasic program I wrote that contains a utility to do exactly what you need - transfer objs from one table to another based on a common primary key.
Darren
From: [EMAIL PROTECTED]
Reply-To: [email protected]
To: [email protected]
Subject: MapInfo-L Digest, Vol 11, Issue 58
Date: Fri, 29 Sep 2006 12:01:10 -0500
>Send MapInfo-L mailing list submissions to
> [email protected]
>
>To subscribe or unsubscribe via the World Wide Web, visit
> http://www.directionsmag.com/mailman/listinfo/mapinfo-l
>or, via email, send a message with subject or body 'help' to
> [EMAIL PROTECTED]
>
>You can reach the person managing the list at
> [EMAIL PROTECTED]
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of MapInfo-L digest..."
>
>
>Today's Topics:
>
> 1. converting GRD to ESRI format (Ross Charles Johnson)
> 2. Re: Copying objects to tables (Stephanie Kiem)
> 3. MapInfo-L Reminder (Bill Thoen)
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Thu, 28 Sep 2006 12:01:32 +1000
>From: "Ross Charles Johnson" <[EMAIL PROTECTED]>
>Subject: [MI-L] converting GRD to ESRI format
>To: "North Coast GIS Group North Coast GIS Group" <[EMAIL PROTECTED]>
>Message-ID: <[EMAIL PROTECTED]>
>Content-Type: text/plain; charset="iso-8859-1"
>
>Dear GIS peoples, I have a GRD file from MapInfo Vertical Mapper and wish to display this inESRI ArcMap. I am using version 9.0 of ArcMap.I have tried the DEM to Raster option from the ESRI ArcToolbox but it does not
>complete the processing.Has anyone had experience in this area?Thanks Ross
>
>Ross JohnsonEnvironmental Scientist (GIS)SMEC Australia Pty Ltd
>-------------- next part --------------
>An HTML attachment was scrubbed...
>URL: http://www.directionsmag.com/pipermail/mapinfo-l/attachments/20060928/ae42a295/attachment-0001.htm
>
>------------------------------
>
>Message: 2
>Date: Fri, 29 Sep 2006 08:49:20 +1000
>From: Stephanie Kiem <[EMAIL PROTECTED]>
>Subject: [MI-L] Re: Copying objects to tables
>To: [email protected]
>Message-ID:
> <[EMAIL PROTECTED]>
>Content-Type: text/plain; charset=US-ASCII
>
>
>
>
>
>
>If you don't have access to MapBasic or some other code writing tools you
>are pretty much stuck with doing it the way you are. Unfortunately the
>column update tool does not extend to the .obj field. However when you do
>the join you don't need to include all the fields from both tables. In your
>steps you said that you were deleting the fields from Table 3 you didn't
>want, just exclude these from the join and you will just have to save &
>rename the resulting table.
>
>Stephanie
>
>
> >Message: 5
> >Subject: [MI-L] Copying objects to tables
> >To: [email protected]
> >
> > Hi,
> >
> > I am using Mapinfo Pro 7.8 and I can't find an easy way to copy objects
>from one table to another. I have a table_1 that has (non point) objects
> >attached to its records, and a table_2 that is unmapped. They have a
>common primary key. I want to copy objects from table_1 to table_2 in a
>simple >manner. Right now, the easiest way I found is to join both tables,
>save a copy as table_3, remove table_1 specific fields in table_3, then
>delete >table_2 and rename table_3 as table_2. If there are fields in
>table_2 that are not found in table_1, there are a couple of extra steps
>necessary to >retrieve unmappable records in table_2, append them to
>table_3, and re-sort table_3 prior to renaming it table_2. I believe there
>has to be an easier >way to update objects in tables, but I have not found
>one so far. Thanks for your help,
> >
> >
> >Francois Blanc.
>
>
>
>___________________________________________________________________________________________________
>A person using Connell Wagner drawings and other data accepts the risk of :
>* Using the drawings and other data in electronic form without requesting
>and checking them for accuracy against the original hard copy version ;
>* Using the drawings or other data for any purpose not agreed to in
>writing by Connell Wagner. (ABN 54 005 139 873)
>This e-mail message and any attached files may hold confidential
>information. If you are not the intended recipient any use, disclosure or
>copying of this e-mail is unauthorised. If you have received this e-mail in
>error please notify the sender immediately by reply e-mail.
>
>
>
>------------------------------
>
>Message: 3
>Date: Fri, 29 Sep 2006 05:00:02 -0600
>From: Bill Thoen <[EMAIL PROTECTED]>
>Subject: [MI-L] MapInfo-L Reminder
>To: [email protected]
>Message-ID: <[EMAIL PROTECTED]>
>Content-Type: text/plain; charset=unknown-8bit
>
>To: [email protected]
>From: [EMAIL PROTECTED]
>Subject: MapInfo-L Reminder
>
>This is just a reminder to help you manage your MapInfo-L subscription. This will be posted automatically each week, and please feel free to respond with suggestions or improvements.
>
>Check out the MapInfo-L wiki at http://www.mapinfo-l.com set up for us by Eric Frost <[EMAIL PROTECTED]>. Wikis are a very cool tool for building a community knowledge base. Join in and make your mark!
>
>- Bill Thoen and Peter Horsbøll Møller
>[EMAIL PROTECTED]
>
>CONTENTS
>0. HOW TO POST MAIL TO MAPINFO-L
>1. HOW TO SUBSCRIBE/UNSUBSCRIBE
>2. HOW TO CHANGE YOUR SUBSCRIPTION SETTINGS
>3. WHERE TO GO TO FIND NEWS WHEN THE LIST BREAKS
>4. MAPINFO-L ARCHIVES
>
>--
>0. HOW TO POST MAIL TO MAPINFO-L
>
>If you are subscribed to the list, then sending mail to
>[email protected] will send your message to everyone on the
>list.
>
>
>1. HOW TO SUBSCRIBE/UNSUBSCRIBE
>
>You can subscribe, unsubscribe or change your account settings by going to
>http://www.directionsmag.com/mailman/listinfo/mapinfo-l. To subscribe, enter
>your email address and optionally your name, and then pick a password. A
>confirmation message will be sent to you, and after you confirm your request
>for subscription, you will begin receiving new mail from the list and will also
>be able to post mail to the list.
>
>To unsubscribe or change your account settings, go to the bottom of this
>page where you will see form controls that you can use to modify your account.
>
>You can do this all with email too. Just look at the X-headers in any
>MapInfo-L message and you'll see the addresses to send a blank email to to
>make the server do what you want.
>
>2. HOW TO CHANGE YOUR SUBSCRIPTION SETTINGS
>
>You can change your account settings by going to
>http://www.directionsmag.com/mailman/listinfo/mapinfo-l. At the bottom of the
>page are form controls where you can specify your address and password to get
>access to your account settings form.
>
>
>3. WHERE TO GO TO FIND NEWS WHEN THE LIST BREAKS
>
>Occasionally the angel of digital chaos descends on the 'net and sometimes
>smites MapInfo-L. Should this happen, you can find news and information about
>what's happening by going to http://www.gisnet.com/mapinfo-l.htm.
>
>
>4. MAPINFO-L ARCHIVES
>
>The MapInfo archives are now available at
>http://www.directionsmag.com/pipermail/mapinfo-l/.
>
>
>
>------------------------------
>
>_______________________________________________
>MapInfo-L mailing list
>[email protected]
>http://www.directionsmag.com/mailman/listinfo/mapinfo-l
>
>
>End of MapInfo-L Digest, Vol 11, Issue 58
>*****************************************
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
