Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Hyderabad, A.P., India
    Posts
    29

    Unanswered: Export from SQL Server to MS-Access

    I have a database in sql server with more than 150 tables. Now, i exported the whole of the database in to MS-Access using DTS wizard. But all the constraints or relationships existing between sql tables are lost after export. Now, i want, can we export databse without losing the constraints or relations between tables. Can anybody help me??"
    Last edited by mrameshchandra; 12-26-03 at 06:20.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I don't believe so. But there may be better ways to accomplish what your goal.

    Why are you exporting the database?

    blindman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •