Post reply

to import datatable from one database to another database

  • May 7, 2010 at 8:03 am

    #234818

    Hi All,

    I am Using two password protected databases in my project, Say DB1.mdb and DB2.mdb. Password for DB1 = 1 and password for DB2=1.

    I need to import datatable say FirstTermExam present in DB1 and to store it as TempFirstTermExam in DB2. I have used this query:

    INSERT INTO TempFirstTermExam

    SELECT * FROM FirstTermExam IN 'C:\aa\ DB1 .MDB'

    but i am getting error as "not an valid password".

    I am using ms acess.

  • May 7, 2010 at 9:42 pm

    #1164516

    Don't know what platform you are using to execute the queries -- I'm assuming it's a centralized platform like dotNet and not a query designer from inside Access.

    Only way I can think of to do it is to create two ADODB connections (one to each database), then manually load a recordset from the first and insert it into the second.

    You may be able to get better help by posting in an Access forum. This forum (and site) is all about SQL Server.

    Try http://www.accessforums.net/

    Good luck!

  • May 8, 2010 at 8:13 pm

    #1164652

    rajath 82072 (5/7/2010)

    I am using ms acess.

    I believe you'll have much better luck getting an answer if you ask that same question on the Access forum.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply