First, build a database with sql.
Select all tasks
input data
Select microsoft from the data source.
approach
Several problems that should be paid attention to when importing access database into mssql database
Using mssql
Server is different from access in many ways, even from sql.
There are also many things that need to be paid attention to when the server imports the access database. Here, let's give a few examples.
1, the automatic numbering field that is often used in access, is not self-increasing int after being imported into mssql, and needs to be set manually. Only when the identity of the imported automatic numbering field changes from No to Yes, and the seed and increment are both 1, can it become automatic numbering.
2. In mssql.
There are many reserved words in server, but not in access. Import the data into mssql, and the problem will come out. When importing mssql, "[field name]" will be automatically added to these fields (including table names in the database). Therefore, you must modify the script to put the corresponding field names (or table names) in parentheses, or change the field names to non-mssql reserved words. (See related materials for details. )
Everyone likes to use "choice" when talking about the use of time with access.
*
from
aaaa
During ...
Time = "