Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    9

    Unanswered: Send results from db to db

    im trying to send user information from a temp db table to a main database...i need the information to be placed in the main db without coping the whole temp over...when i copy the whole temp over it erases everything in my main db...is there any way...thanks for your time...

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,477
    Provided Answers: 11
    Why not just LINK the Main Database to the Temp Database and do a sql update?
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  3. #3
    Join Date
    Jun 2004
    Posts
    9
    that seems like a better option...i've been trying to write a sql statement in asp to update the other table and it seems to not want to work...i'm trying to take all of the information FROM tempusers_tbl TO users_tbl...i have linked the two databases together and that worked fine...here is my code...

    Dim name, sSQL

    sSQL = "update t1
    set name = 't2.name'
    from users_tbl t1 inner join tempusers_tbl t2"

    thanks for your time...

Posting Permissions

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