CODEWITHSUNDEEP
sql-serverms-accessexport
Shailesh
Shailesh

Reputation: 492

Export Sql Server 2008 database into MS Access Database

I want to export Sql Server 2008 table objects into MS Access database . I try to find it but not got any perfect way to solve the given problem. Please suggest what should i do.

Upvotes: 1

Views: 25226

Answers (2)

pankeel
pankeel

Reputation: 1148

follow this step to export to ms acess:

  1. Right click on your database -> Task -> Export Data

  2. Choose your data source and database

  3. Click on next choose your destination database in destination combo select ms Access Database select file of Access database

  4. Click next: copy data from tables or views...

  5. Click next: select all tables

  6. Click next

  7. Click finish

    Screenshot of choose access database export

Username & password must be blank

Upvotes: 2

Shailesh
Shailesh

Reputation: 492

You can do in from Import Wizard from an MS Access file

  1. Create a MS Access database.
  2. Go to the External Data tab Import & link Section.
  3. Make an ODBC Database connection with SQL database
  4. Import tables(consider excluding schema and system tables if you do not need them)

Upvotes: 4

Related Questions