I have installed SQL Server 2005 Enterprise Edition on a Windows 2003 Server.
What are the procedures to import data from Access database into a SQL
Server 2005 database?

In SQL Server 2000 it was so easy to import data with the DTS program.

Please help me with the procedures to import the Access database data into a
SQL Server 2005 database.

Thanks,

It is still very easy with SSIS (SQL Server Integration Services)

If you look at the Books On Line, there are tutorials on how to work with
SSIS very quickly. It won't take long and soon as you understand the basic
concepts you will see how easy it is to drop in a few controls and poof you
are done.

hth, Mike

"Joe K." <Joe K. (AT) discussions (DOT) microsoft.com> wrote

Hello Joe,

If you want to use the wizard then a good place to find it is

Right click on a DB in SSMS
Tasks
Import Data

We have example articles of using SSIS

here

http://www.sqlis.com/?15

and here

http://wiki.sqlis.com/lastmodified.a...pace=SQLISWiki

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com