Sunday, August 16, 2009

How do I import Access Database into SQL Database(2000)

1.Right click on any database
2.Select ALL TASKS and then select IMPORT DATA after clicking
3.One dialog box will appear,click NEXT
4. And choose MICROSOFT ACCESS as DATA SOURCE, what displayed on the following picture.

Then BROWSE ur access file then click NEXT(keep username and password blank)
5.Chosse the DESTINATION[SQL native client].Click on properties

6.Chosse Data Source(localhost),select a specific username and password.
(With sa sa),Chosse Database from Initial Catalog.Click Ok.
7.Click Next.

8.Select copy tables and views from source database then click next
9.Select all tables,click Next.
10.Check run immediately,click Next.
11.Click finish.

1 comment:

shail2chouhan said...

Nice blog and great experience share u are doing a great work.