How Migrate from MS Access to SQL Server 2005? - Backup, Recovery and Disaster Recovery

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Backup, Recovery and Disaster Recovery » How Migrate from MS Access to SQL Server 2005?

How Migrate from MS Access to SQL Server 2005?

Options

Previous Topic · Next Topic

forums_4m

Posted: Saturday, May 03, 2008 6:22:44 AM

Rank: Newbie

Joined: 5/3/2008
Posts: 0
Points: 3

Hi SQL Server Team,

Data migration from MS access to Sql server 2005.

In client having existing system is MS Access. So I want to migration MS Access system to SQL server 2005.

Let suppose there MS Access one table having 10 fields.

That table data i need migrate in system (sql server 2005), but the field name are different & sql server few fields are extra suppose 15 fields or vise versa.

So can any one help me out, how to migrate the MS access to sql server system?

Please give me if any one the script or step do this.

Thanks & regards

Scott Whigham

Posted: Sunday, May 04, 2008 11:17:05 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 329
Points: 700
Location: Dallas, TX

Use SSIS' Import & Export Wizard - you can do it in less than 10 minutes. If you haven't used it or want more info, check out the vid tutorials at Importing Microsoft Access Data to SQL Server

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.