Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: Import a Table from one db toanother

    I have 2 db, once a week i copy a table from one db to the other, how can i do this in vba? the table is Deal and its in DMS.mdb, i would like to code from FE.mdb becuase i will later manipulate the table. So i would like to code in FE.mdb how to import deal table from DMS.mdb


    tks!

    M~

  2. #2
    Join Date
    Nov 2003
    Location
    Warren, PA
    Posts
    52
    DoCmd.TransferDatabase acImport, "Microsoft Access", "D:\Access\dms.mdb", acTable, "Deal", "Deal", False

    Brent

  3. #3
    Join Date
    Nov 2003
    Location
    Warren, PA
    Posts
    52
    DoCmd.TransferDatabase acImport, "Microsoft Access", "D:\Access\dms.mdb", acTable, "Deal", "Deal", False

    Brent

Posting Permissions

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