Would you like to post your query statement?
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Htk" <sky5@optusnet.com.au> wrote in message
news:3fa76f87$0$9262$afc38c87@news.optusnet.com.au ...[color=blue]
> There is no primary key designated in the either tables and both tables[/color]
have[color=blue]
> all the field names Indexed at "YES (duplicates OK ).
> I still don't know why it won't simply add data instead of replacing the
> existing ones.
>
>
> "Allen Browne" <allenbrowne@SeeSig.invalid> wrote in message
> news:3fa4e335$0$1731$5a62ac22@freenews.iinet.net.a u...[color=green]
> > An append query should add new records to the existing table without[/color]
> losing[color=green]
> > the records you have there. Are you sure that there is no reason why the
> > records cannot be added, e.g. they reuse the primary key values, or they
> > would create duplicates where none are permitted?
> >
> > --
> > Allen Browne - Microsoft MVP. Perth, Western Australia.
> > Tips for Access users -
http://allenbrowne.com/tips.html
> > Reply to group, rather than allenbrowne at mvps dot org.
> >
> > "Htk" <sky5@optusnet.com.au> wrote in message
> > news:3fa4c270$0$30392$afc38c87@news.optusnet.com.a u...[color=darkred]
> > > I have two access databases. A and B
> > > Both have a table with the same name (tbl_data entry) ie. same
> > > structure/data.
> > > I want to be able to transfer (export) data in this table from[/color][/color][/color]
database[color=blue]
> A[color=green]
> > to[color=darkred]
> > > the same named table in database B - but i want the transferred data[/color][/color][/color]
to[color=blue][color=green]
> > be[color=darkred]
> > > ADDED to existing data already in database B.
> > >
> > > I have tried the append query method but that simply REPLACES the[/color]
> > existing[color=darkred]
> > > table data in B with the incoming data from database A.
> > > I have tried creating a macro with the 'transferDatabase' action[/color][/color][/color]
command[color=blue][color=green][color=darkred]
> > > option - that too simply replaces the existing table data in database[/color][/color][/color]
B.[color=blue][color=green][color=darkred]
> > >
> > > I know that i can simply use the export function and rename the table[/color][/color]
> that[color=green][color=darkred]
> > > transfers to database B. Then copy/paste the data to the required[/color][/color][/color]
table.[color=blue][color=green][color=darkred]
> > > But I'd rather have a transfer method that adds data (table data from
> > > database A) to the existing table data in database B.
> > > Appreciate any help on this.[/color][/color][/color]
