Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2002
    Posts
    3

    Question Unanswered: linking tables from MS Access and SQLserver

    I have a very big and important SQLserver db and a small Student db in a school.
    The studentdata is moved once a year to the studentdb and there student can adapt there data.
    Now I have to take care of the linking part meaning: the data has to be moved back to the big db for consistency.

    How can I do this??
    I have absolutely no idea cause I'm a newbie.

    Please help me

    Myri
    Last edited by Myri; 11-26-02 at 09:30.

  2. #2
    Join Date
    Nov 2002
    Posts
    150

    Re: linking tables from MS Access and SQLserver

    Need more info:

    Was the data physically moved from the SQL Server to an Access database?

    How many tables were updated in the Student database?

    Was data added, deleted, or just updated?

  3. #3
    Join Date
    Aug 2002
    Posts
    28
    In the SQL Server Enterprise Manager, there is a wizzard for importing and exporting data. It is very straight forward, you just ned to pick your souce and destination and hit finish. Otherwise you could create a local DTS package which will do this for you.. You should be able to find a quick tutorial on the web.

    Not much detail here but should point you in the right direction.

    Paul

  4. #4
    Join Date
    Nov 2002
    Posts
    3

    Re: linking tables from MS Access and SQLserver

    Was the data physically moved from the SQL Server to an Access database?
    Yes

    How many tables were updated in the Student database?
    One or two

    Was data added, deleted, or just updated?
    Updated

  5. #5
    Join Date
    Nov 2002
    Posts
    3
    Problem is that it would be ideal if all this linking would be dynamic.
    Is this possible??

  6. #6
    Join Date
    Nov 2002
    Posts
    4
    Originally posted by Myri
    Problem is that it would be ideal if all this linking would be dynamic.
    Is this possible??
    Have at look at using ODBC from the Admin Tools in your control panel (Windows 2000)

    this creates a linking for you to link directly to the SQL database

Posting Permissions

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