Method 1: Previous posts said that this is said to select the source table and attempt to use the DTS step, click the conversion column with the auto number table, open the column mapping, and conversion dialog box, click Edit SQL button. , Modify, for example, the following statement. Create Table `Tid` (` a` Varchar (10) null) for Create Table `Tid` (` Idcol` counter Null, `a` VARCHAR (10) null Then determine, then continue to demonstrate 2: 1. Establish a table with the same structure as the original data table, add a "automatic number" field. 2. Add a record in this data table until the maximum value of Auto Number has reached the maximum value of the number of seeds in the original data table. 3, use the update statement to update: Update new data table name Inner Join Old SQL Data Name ON New Data Table Name. Auto Number Field Name = Old SQL Data Table Name. Seed Field Name Set New Data Table. Other Fields = [Old SQL Data Table]! [Other Fields]; 4. Delete excess records in the new data table. Methods I tried it, I didn't make it, I don't know if I have a problem.
