import access into SQL

Message Topic Search Topic Options Post Reply Create New Topic Create New Poll Printable Version Translate Topic

   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.

Author	Message Topic Search Topic Options Post Reply Create New Topic Create New Poll Printable Version Translate Topic
reaper Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 27 Jan 2022 Status: Offline Points: 367	Post Options Post Reply Quote reaper Report Post Thanks(0) Quote Reply Topic: import access into SQL Posted: 04 Feb 2022 at 3:14pm
	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.

Sponsored Links