473,321 Members | 1,877 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

Exporting

Htk
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 database A to
the same named table in database B - but i want the transferred data to be
ADDED to existing data already in database B.

I have tried the append query method but that simply REPLACES the existing
table data in B with the incoming data from database A.
I have tried creating a macro with the 'transferDatabase' action command
option - that too simply replaces the existing table data in database B.

I know that i can simply use the export function and rename the table that
transfers to database B. Then copy/paste the data to the required table.
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.

Nov 12 '05 #1
3 2149
An append query should add new records to the existing table without losing
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" <sk**@optusnet.com.au> wrote in message
news:3f***********************@news.optusnet.com.a u...
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 database A to the same named table in database B - but i want the transferred data to be ADDED to existing data already in database B.

I have tried the append query method but that simply REPLACES the existing table data in B with the incoming data from database A.
I have tried creating a macro with the 'transferDatabase' action command
option - that too simply replaces the existing table data in database B.

I know that i can simply use the export function and rename the table that
transfers to database B. Then copy/paste the data to the required table.
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.

Nov 12 '05 #2
Htk
There is no primary key designated in the either tables and both tables have
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" <al*********@SeeSig.invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
An append query should add new records to the existing table without losing 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" <sk**@optusnet.com.au> wrote in message
news:3f***********************@news.optusnet.com.a u...
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 database A
to
the same named table in database B - but i want the transferred data to

be
ADDED to existing data already in database B.

I have tried the append query method but that simply REPLACES the

existing
table data in B with the incoming data from database A.
I have tried creating a macro with the 'transferDatabase' action command
option - that too simply replaces the existing table data in database B.

I know that i can simply use the export function and rename the table

that transfers to database B. Then copy/paste the data to the required table.
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.


Nov 12 '05 #3
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" <sk**@optusnet.com.au> wrote in message
news:3f**********************@news.optusnet.com.au ...
There is no primary key designated in the either tables and both tables have 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" <al*********@SeeSig.invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
An append query should add new records to the existing table without losing
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" <sk**@optusnet.com.au> wrote in message
news:3f***********************@news.optusnet.com.a u...
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 database A
to
the same named table in database B - but i want the transferred data
to
be
ADDED to existing data already in database B.

I have tried the append query method but that simply REPLACES the

existing
table data in B with the incoming data from database A.
I have tried creating a macro with the 'transferDatabase' action

command option - that too simply replaces the existing table data in database B.
I know that i can simply use the export function and rename the table

that transfers to database B. Then copy/paste the data to the required table. 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.

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: sridevi | last post by:
Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works...
3
by: sridevi | last post by:
Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works...
3
by: sridevi | last post by:
Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works...
2
by: bienwell | last post by:
Hi, I have a question about exporting data from datagrid control into Excel file in ASP.NET. On my Web page, I have a linkbutton "Export data". This link will call a Sub Function to perform...
2
by: Snozz | last post by:
The short of it: If you needed to import a CSV file of a certain structure on a regular basis(say 32 csv files, each to one a table in 32 databases), what would be your first instinct on how to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.