Beowulf
Guest
|
 Posted: Tue Feb 10, 2004 1:58 pm Post subject: Copy contents of ADOconnection1 to ADOconnection2 while addi |
 |
|
Hi
I have a slight problem. I thought this would be easy but it's causing
me a few headaches!
I have an ADOconnection pointing to an Access MDB full of live data.
I have a second ADO connection pointing to an ALMOST identical mdb
file except some extra fields have been added.
Each MDB file has approx 30 tables.
I am trying to write a procedure to copy all the data from all the
tables in my Source mdb (ADOconnection1) and copy it to my Destination
mdb (ADOConnection2) and at the same time add in each records new
field data.
For example, suppose I have 1 table in each mdb file with a structure
of
Name,
Age,
Shoesize
and I want to create a new table with the following info
Name,
Age,
Shoesize,
IQ,
Favorite_IceCream.
( I suppose so I collate if People with big feet and high IQ prefer
Choclate to Strawberry! <g> )
Is there an EASY way to do this? As I copy the records across I would
be assigning a value to my new fields.
I suppose I could just copy the MDB file , add in the new fields in
Access design view, then itterate through each table adding in the new
data?? I'm getting myself all confused..
any assistance greatly appreciated.
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
