Member Avatar for knrakesh

hello friends,
how to import .MDB file to sql server
please tell in detail

please

Rakesh Nagekar

  • 2 Contributors
  • 1 Reply
  • 76 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by greeny_1984
Member Avatar for greeny_1984

hi,
1.open enterprise manager in sql server
2.right click on the database u want to import data.
3.select import option in properties.
4.in choose a datasource ,chose microsoft access,enter the location where access database is present.
5.choose destination as sqlserver,in the database select the database u want to import data from.
6.click next,choose u r tables
7.click finish

u will have u r tables in sql server

commented: Nice step-by-step guide, however use of full sentence English would be far better. +10
commented: Nice Explanation.... +2
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.