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,424
    Provided Answers: 8
    Why not just LINK the Main Database to the Temp Database and do a sql update?
    hope this help

    See clear as mud


    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 based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  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
  •