Welcome to SPN

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

Sign Up Now!

Export form data to existing table

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

  1. MarcoR

    MarcoR
    Expand Collapse
    Guest

    I have a Access database with hundreds of customer info.
    I created a filtered form with a command button to export indivisual
    customer info to Excel.
    Now, I wanted to export the same filtered form data to a table in another
    Access database.
    I tried with TransferDatabase macro, but it would transfer ALL the
    customers' info.
    I just need to transfer a customer(the filtered) info.
    How is this done?
     
  2. Loading...

    Similar Threads Forum Date
    World Polish exports of meat for Jews, Muslims in limbo Breaking News May 16, 2013
    India's Leading Export: CEO's Inspirational Stories Jul 23, 2011
    India India's Latest Export: Rent-a-Womb Breaking News Dec 22, 2010
    Sikh News Banning of export of milk powder will be a retrogade step, says Punjab MP Gujral (New Breaking News Jun 4, 2008
    Sikh News Punjab's Steel Producers Seek Ban On Iron Ore Export (Nasdaq) Breaking News Feb 26, 2008

  3. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    Marco,

    TransferDatabase should work, but you will have to use a Query that
    returns the required records as the Source argument, rather than your table.

    Another option is to use an Append Query, something along these lines...
    CurrentDb.Execute "INSERT INTO Customers IN 'C:\YourFolder\Other.mdb'" & _
    " SELECT CustomerID, CustomerName, etc" & _
    " FROM YourQuery", dbFailOnError

    --
    Steve Schapel, Microsoft Access MVP

    MarcoR wrote:
    > I have a Access database with hundreds of customer info.
    > I created a filtered form with a command button to export indivisual
    > customer info to Excel.
    > Now, I wanted to export the same filtered form data to a table in another
    > Access database.
    > I tried with TransferDatabase macro, but it would transfer ALL the
    > customers' info.
    > I just need to transfer a customer(the filtered) info.
    > How is this done?
     

Share This Page