Can you do it with a SQL insert? Insert into newtable select field1, field2, transform(field3) field3, upper(field4) field4, ... from oldtable
I'd also drop any index tags on the new table before inserting and then add after the insert is done. -- rk -----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Tuesday, October 25, 2011 1:04 PM To: profoxt...@leafe.com Subject: Insert Into with memo fields I am importing a very large database from one version of a table to another version of a table with a few conversions. I use the scatter name object blank and fill the objects with the data I want. Then I do an append blank and gather name object. This works fine. I wanted to speed things up by using an insert into. I tried scatter memo name object and then doing a insert into newtable from name o and I get a data type mismatch on the insert. It appears to be from the memo field. I tried scatter name object and then insert into newtable from name o and got the same message. Is there any way to optimize this when using a memo field? There are 72 fields and I don't really want to go the route of a full insert into command. Any ideas? -- Jeff --------------- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD0441BBA9C69BC@ACKBWDDQH1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
