From access to MS SQL Server data import?

access|server| data


There are generally two ways:



The first is to use MS SQL Server's DTO for import operations, step-by-step prompts to operate the line. However, the possible field properties in this process will change and the primary key is gone. This method is usually used in conjunction with SQL table statements.

Another approach is to take the Database Upsizing Wizard provided by Access, with none of the previous bugs, and no hidden bugs at the moment. This upgrade method should be preferred.