>>I'm converting a lot of data for the new version of the program. I've been using SELECT with AS to get the data and change the field names. Then I APPEND into the new table. This works, but is time consuming.
>>
>>What I was wondering is: Is there a way to get the data directly from one table to another?
>>
>>Like: APPEND FROM oldtable FIELDS client_num AS clientID, tripnum AS tripkey (etc)
>>
>>The above doesn't work, so I know that's not how to do it. :) Is there any command that would do it?
>>
>>Thanks,
>>
>>Michelle
>
>You may speed up things a little bit doing following:
>1. ALTER TABLE oldtable (to get right field names etc., you may back up old table if necessary).
>2. APPEND FROM oldtable

Hmmm... I suppose that would work. I was hoping for something more direct.

Thanks,

-Michelle