Thanks Dad. I had to use a view (so I could rename the columns to be the same as my destination table) and then I used the APPEND function. Works great!
Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Friday, March 13, 2009 9:26 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: append table If the field names are the same I would use append. It will ignore the other fields. Dan ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Friday, March 13, 2009 7:18 AM To: RBASE-L Mailing List Subject: [RBASE-L] - append table I have built a temporary table that will eventually be used to import information into a permanent table. I will be importing (or appending, inserting) into the temp table, info contained in a table created from outside info where the fields are all note fields. This table is already in the database. I will only be using certain fields to go into the temp table. Here is the question. Since I will have more fields in the temp table than the number of fields I will insert, what is the best method for doing this? Jim
