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