Access database in MS SQL Server

General discussion on MS Access and its databases.

Access database in MS SQL Server

Postby ann_mooly » Thu Dec 12, 2013 5:47 am

Hey friends!
How do you import an Access database to MS SQL Server? I'm using MS Access 2007 and need to import an Access database to MS SQL Sever.
I know there is an import feature in MS SQL, but don't how to use it.
Need your help.
ann_mooly
 
Posts: 15
Joined: Thu Oct 18, 2012 5:50 am
Location: Britain

Re: Access database in MS SQL Server

Postby SteveJ » Thu May 01, 2014 5:09 am

Hey dear,

Don't worry!...I have a solution to your problem.

SSIS (SQL Server Integration Services) is a feature in SQL Server Business Intelligence Development Studio application by using which you can import your database files of MS Access to SQL Server. The procedure is quite and typical which requires you to execute lot of steps.

If you want to note the steps, then you can visit this blog post: import MS Access data into SQL Server using SSIS.

:)
SteveJ
 
Posts: 20
Joined: Tue Mar 25, 2014 6:31 am


Return to MS Access- Help Forum

Who is online

Users browsing this forum: No registered users and 1 guest

cron