1. Open SQL Server Enterprise Mananger "Enterprise Manager"
In the SQL database you want to export, right-click menu: All Tasks-"Export data"
2. Returns an Export wizard window.
Select the exported data source, for the database you have just chosen, if found does not correspond to its own modification.
3. Enter the selection to export to the target data source, where we'll turn to the database for access. Note Selecting the data source type is Microsoft Access. Click the button behind the filename (F) to select the target. MDB file.
4. Select "Copy tables and views from database"
5. We note that there is a "conversion" column on the right side of the table selection. SQL export converts only data types regardless of other scripts so the AutoNumber problem we're encountering is here. There is a certain point of automatic numbering select "Convert".
6. We see a "column Mapping and Transformation" dialog box. Noticed that the self increasing of the EmployeeID int has become a long in access. This is definitely not true, long is not automatic numbering, had to modify the build table script, the picture on the Red circle button "edit SQL."
Open a small window create Talbe
The script in the red circle is the EmployeeID Access table script, preceded by "not NULL" with "IDENTITY (1, 1)".
7. Immediate implementation.
The following figure indicates that the table replication was successful
8. We open the MDB file to see if it's what we want?
OK, congratulations on your successful operation.