Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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.

    > >
    > >

    >
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page