>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