Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Unanswered: Exporting data between databases

    Just starting out with MSSQL 2000 and have a bit of a problem.
    I have a remote database that is of the same design of a local database. What I want to do is update one particular field of each record in my local database with data from the remote one. Of course the primary key of each of the records from the remote dbase and the local dbase must match (as even though the remote database has the most up-to-date information, it has more records in it than my local one (but I do not require the additional records).

    How on earth do I do this? I could use the DTS based on a query, but how can I ensure that the data goes in the correct records' field?

    Any help would be appreciated!

    Thanks.

  2. #2
    Join Date
    Nov 2003
    Posts
    9

    Re: Exporting data between databases

    If you have ACCESS 2000 or 2002 you can create two linked tables.

    One to each table and then use access to run your update, then you can run you insert of the additional fields at the same time.

  3. #3
    Join Date
    Dec 2002
    Posts
    29

    Re: Exporting data between databases

    Originally posted by Odin_the_Celt
    How on earth do I do this? I could use the DTS based on a query, but how can I ensure that the data goes in the correct records' field?
    What about using the primary keys for unique identifing the records? And using Inner Join in the update statement.

    Best regards!

  4. #4
    Join Date
    Dec 2002
    Posts
    29

    Re: Exporting data between databases

    Originally posted by Odin_the_Celt
    How on earth do I do this? I could use the DTS based on a query, but how can I ensure that the data goes in the correct records' field?
    What about using the primary keys for unique identifing the records?

    Best regards!

Posting Permissions

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