Welcome to SPN

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

Sign Up Now!

Merging 2 different access databases ??

Discussion in 'Information Technology' started by iamwhatiam, Nov 1, 2005.

  1. iamwhatiam

    iamwhatiam
    Expand Collapse
    Guest

    How can I merge 2 different access databases ???

    I need to manually match different fields to merge.

    Or is there a program available that can do it.

    The closest I have got, is to export one database as a CSV, and then
    import it into the other database. But it does not let me say which
    fields in the source database match which fields in the target
    database. I thus get error message saying that some fields are
    incompatible.
     
  2. Loading...

    Similar Threads Forum Date
    India Punjab emerging as major drug producing centre Breaking News Mar 13, 2013
    Under-19 emerging sikh cricketers Sports & Fitness Jan 22, 2010
    Merging in the Word Of Sabad Sikh Sikhi Sikhism Jan 26, 2008
    Sikh News Punjab emerging as new international education hub (New Kerala) Breaking News Sep 17, 2007
    Sikh News Punjab emerging as new international education hub (ANI via Yahoo! India News) Breaking News Sep 17, 2007

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    If it were me, I'd link the tables from one database in the other. I'd then
    build update and append queries to copy data from one table to the other.
    I'd then delete the links and delete the original duplicate database.

    Before doing any of this, I'd make at least one good backup of each file.

    --
    Rick B



    "iamwhatiam" <agent@agent.com> wrote in message
    news:rdicm190a67pkssk5mivd8i8ma0vcfbcho@4ax.com...
    > How can I merge 2 different access databases ???
    >
    > I need to manually match different fields to merge.
    >
    > Or is there a program available that can do it.
    >
    > The closest I have got, is to export one database as a CSV, and then
    > import it into the other database. But it does not let me say which
    > fields in the source database match which fields in the target
    > database. I thus get error message saying that some fields are
    > incompatible.
     
  4. iamwhatiam

    iamwhatiam
    Expand Collapse
    Guest

    Tried append queries, but I keep getting 'type conversion failure'
    when trying to run the query.

    I've only selected one field to append, and I've also checked to make
    sure both source and destination database field types are the same. I
    still get 'type conversion failure'.

    It also tells me in the error message that there 18063 records will be
    updated. The source database has only 81 records and the destination
    database has only 223 records.
     
  5. jojo

    jojo
    Expand Collapse
    Guest

    good morning
    "Rick B" <Anonymous> wrote in message
    news:eZPDv$j3FHA.472@TK2MSFTNGP15.phx.gbl...
    > If it were me, I'd link the tables from one database in the other. I'd

    then
    > build update and append queries to copy data from one table to the other.
    > I'd then delete the links and delete the original duplicate database.
    >
    > Before doing any of this, I'd make at least one good backup of each file.
    >
    > --
    > Rick B
    >
    >
    >
    > "iamwhatiam" <agent@agent.com> wrote in message
    > news:rdicm190a67pkssk5mivd8i8ma0vcfbcho@4ax.com...
    > > How can I merge 2 different access databases ???
    > >
    > > I need to manually match different fields to merge.
    > >
    > > Or is there a program available that can do it.
    > >
    > > The closest I have got, is to export one database as a CSV, and then
    > > import it into the other database. But it does not let me say which
    > > fields in the source database match which fields in the target
    > > database. I thus get error message saying that some fields are
    > > incompatible.

    >
    >
     
  6. Julia

    Julia
    Expand Collapse
    Guest

    I don't understand this either. I tried highlighting one database, copying
    it, and pasting it into the other one, but the "paste" option was gray so I
    couldn't do that. How do you link databases? One is on our shared drive and
    one is on someone else's computer.
    --
    Julia


    "jojo" wrote:

    > good morning
    > "Rick B" <Anonymous> wrote in message
    > news:eZPDv$j3FHA.472@TK2MSFTNGP15.phx.gbl...
    > > If it were me, I'd link the tables from one database in the other. I'd

    > then
    > > build update and append queries to copy data from one table to the other.
    > > I'd then delete the links and delete the original duplicate database.
    > >
    > > Before doing any of this, I'd make at least one good backup of each file.
    > >
    > > --
    > > Rick B
    > >
    > >
    > >
    > > "iamwhatiam" <agent@agent.com> wrote in message
    > > news:rdicm190a67pkssk5mivd8i8ma0vcfbcho@4ax.com...
    > > > How can I merge 2 different access databases ???
    > > >
    > > > I need to manually match different fields to merge.
    > > >
    > > > Or is there a program available that can do it.
    > > >
    > > > The closest I have got, is to export one database as a CSV, and then
    > > > import it into the other database. But it does not let me say which
    > > > fields in the source database match which fields in the target
    > > > database. I thus get error message saying that some fields are
    > > > incompatible.

    > >
    > >

    >
    >
    >
     

Share This Page