Moving Tables and Data
To use the DTS Wizard to transfer your Access data into SQL Server, you can use these steps:
- In SQL Server Enterprise Manager, on the Tools menu, point to Data Transformation Services, and then click Import Data.
- In the Choose a Data Source dialog box, select Microsoft Access as the Source, and then type the file name of your .mdb database (.mdb file extension) or browse for the file.
- In the Choose a Destination dialog box, select Microsoft OLE DB Provider for SQL Server, select the database server, and then click the required authentication mode.
- In the Specify Table Copy or Query dialog box, click Copy tables.
- In the Select Source Tables dialog box, click Select All.