Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Besy way to Copy (or Import) a Table???

Discussion in 'Information Technology' started by Bob Barnes, Jul 28, 2006.

  1. Bob Barnes

    Bob Barnes
    Expand Collapse
    Guest

    Looking for VBA code to either...

    A - Copy a Table to another Access DB...

    or maybe better...

    B - Click a Button in a DB that does "File - Get External Data -
    Import"....then I probably need to delete the Table so I don't get a "1"
    suffix...BUT this Table is LINKED to a POS Card Swipe.

    TIA - Bob
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Akal Takht concerned on drug addiction, copying during exams Breaking News Nov 5, 2013
    SciTech New Quantum Dot Technique Combines Best of Optical and Electron Microscopy Breaking News Jun 17, 2013
    India Copy of 48th Rreport of 'LOKPAL BILL 2011' Presented in Parliament Breaking News Dec 10, 2011
    Bhagats Sheikh Farid Copyright? History of Sikhism Nov 14, 2011
    Christianity Public library find is only surviving copy of rebel hymn book Interfaith Dialogues Jan 8, 2011

  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    To export a table to another MDB, you can use

    docmd.TransferDatabase acExport,"Microsoft Access"
    ,"c:\MDBNameToExportTo.mdb",acTable,"TablesSourceName","TableDestinationName"

    --
    Good Luck
    BS"D


    "Bob Barnes" wrote:

    > Looking for VBA code to either...
    >
    > A - Copy a Table to another Access DB...
    >
    > or maybe better...
    >
    > B - Click a Button in a DB that does "File - Get External Data -
    > Import"....then I probably need to delete the Table so I don't get a "1"
    > suffix...BUT this Table is LINKED to a POS Card Swipe.
    >
    > TIA - Bob
     
  4. Bob Barnes

    Bob Barnes
    Expand Collapse
    Guest

    Ofer - Thank you.

    Bob

    "Ofer Cohen" wrote:

    > To export a table to another MDB, you can use
    >
    > docmd.TransferDatabase acExport,"Microsoft Access"
    > ,"c:\MDBNameToExportTo.mdb",acTable,"TablesSourceName","TableDestinationName"
    >
    > --
    > Good Luck
    > BS"D
    >
    >
    > "Bob Barnes" wrote:
    >
    > > Looking for VBA code to either...
    > >
    > > A - Copy a Table to another Access DB...
    > >
    > > or maybe better...
    > >
    > > B - Click a Button in a DB that does "File - Get External Data -
    > > Import"....then I probably need to delete the Table so I don't get a "1"
    > > suffix...BUT this Table is LINKED to a POS Card Swipe.
    > >
    > > TIA - Bob
     
  5. Ron2006

    Ron2006
    Expand Collapse
    Guest

    Both macros and docmd can

    transfer (multiple types) to export/import/link

    and

    delete object
    and copy object
     

Share This Page