Joel Ok I misunderstood. In that case just before loading your data turn off the autonum by using AUTONUM columname IN tablename DELETE
load your data then sel the max number for the autonum column. Now turn it back on. AUTONUM columname IN tablename USING yourMaxNumberPlus1 1 NONUM Buddy -----Original Message----- From: Joel Solomon [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 1:28 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Loading Data I don't want to affect the numbering in the receiving table ----- Original Message ----- From: "Walker, Buddy" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, October 18, 2004 1:13 PM Subject: [RBG7-L] - RE: Loading Data Joel Why not just renumber your auto numbered column after your load. AUTONUM columname IN tablename USING 1 1 NUM This will renumber your column starting with 1 Buddy -----Original Message----- From: Joel Solomon [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 12:56 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Loading Data Good Afternoon All I need to load data from one computer to another. The data in the first table (in computer 1) has an auto numbered column. The data in the second table (in computer 2) also has an autonumbered column. When I load the data from the first table to the second, I want the autonumber field to re-number sequentially in the second table. I tried to use NONUM and NUM during the load but each caused unexpected negative results. Any suggestions? Joel Solomon Controller Barbizon International [EMAIL PROTECTED]
