Switch to Access from SQLServer

zhaozj2021-02-16  124

1: Your problem is very typical and it is very difficult to solve.

The method I use here is to use a longer time to complete the conversion of the data, using the DDL statement to solve how to make the automatic adding fields grow according to the number you need.

Each additional record is added, change the value of the automatic number field according to SQL Server.

Please refer to: http://www.access911.net/web2/index.asp? Board = 4 & Mode = 3 & RecordId = 74fab71e1bdc

Which master has other better ways, please come out. Thank you

2: You can do this:

1. Establish a table with the same structure as the original data table, add a field of "Auto Number".

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 Name Inner Join Old SQL Data Table Name ON New Data Table Name. Auto Number Field Name = Old SQL Data Table Name. Seed Field Name Set New Data Table Name. Other Fields = [Old SQL Data Table]! [[ Other fields];

4. Delete excess records in the new data table.

转载请注明原文地址:https://www.9cbs.com/read-7865.html

New Post(0)