- Open SQL Server
- Right click on the database folder/node to import
- Click on All tasks
- Click on Import Data
- The Data Transfer Services Wizard screen will appear.
- Click on Next
- The Choose a Data Source screen will appear.
- In the Data Source field, choose Microsoft Access.
- In the file name field, enter C:\taxrates\general.mdb.
- NOTE: Enter the name of the database you are importing: C:\taxrates\states.mdb and C:\taxrates\stateszip4.mdb
- Click on Next.
- The Choose a destination screen will appear.
- The destination should be Microsoft OLE DB Provider for SQL Server. The Server should be the name of your SQL Server. It will not be Jerry.
- Click on Use Windows Authentication if a password is not required. If a password is required, click on Use SQL Server Authentication and enter your username and password.
- At the database field, using the drop down menu, choose New.
- A Create Database dialog box will appear as shown below.
- In the Name field, enter the name of the Access data base that is being imported to the SQL Server. Do not change the default data file or log file sizes.
- NOTE: Be sure to spell the database name in the SQL Server with the exact same name as the MS Access database name. This is necessary to create the new folder.
- Click on OK.
- Click on Next.
- The Specify Table Copy or Query screen will appear.
- Choose Copy table(s) and view(s) from the source database.
- Click on Next.
- The Select Source Tables and Views screen will appear. It will look different for SQL Server 2005.
- Select the top two tables: Accum and Exempt. When you follow these steps later for the states and stateszip4 databases, Click Select All.
- Click on Next.
- The Save, schedule, and replicate package screen will appear.
- In the When box, make sure the Run immediately choice is checked. Don’t click on anything else on this screen at this time.
- Click on Next.
- The Completing the DTS Import/Export Wizard will appear.
- Click on Finish.
- You should see an Executing Package screen which shows progress of the importing of data from Access to the SQL Server as shown above.
- You should see a screen with the Successfully copied 2 table(s) message.
- Click on OK.
- Click on Done.
|