K
Kenny-Z
Hi,
is there a simple way to append all records of an ADO recordset to an
existing JET table with the same number of fields/data types, other
than opening another recordset for the JET table and looping through
each record in the ADO rst copying one by one to the second recordset?
While I'm at it, I might question my solution design:
Consider several Access/JET databases, identical in data structure,
located on several networked PCs. I want to take all records from a
specific table on each workstation and append them to new (temp) table
on one of those workstations. To clarify, there are several sales
persons with individual, private contact tables (in individual MDBs)
on their PCs; I want to merge all contacts into a new table on one PC
for a 'global' address label report...
My current approach uses ADO to first get a list of filespecs (paths)
for the source MDBs from a 'Filespec' table, and then I loop to open a
connection and recordset for each one, somehow appending the records
to the global (temp) table before opening the next file...
thanks for any advice,
kz
is there a simple way to append all records of an ADO recordset to an
existing JET table with the same number of fields/data types, other
than opening another recordset for the JET table and looping through
each record in the ADO rst copying one by one to the second recordset?
While I'm at it, I might question my solution design:
Consider several Access/JET databases, identical in data structure,
located on several networked PCs. I want to take all records from a
specific table on each workstation and append them to new (temp) table
on one of those workstations. To clarify, there are several sales
persons with individual, private contact tables (in individual MDBs)
on their PCs; I want to merge all contacts into a new table on one PC
for a 'global' address label report...
My current approach uses ADO to first get a list of filespecs (paths)
for the source MDBs from a 'Filespec' table, and then I loop to open a
connection and recordset for each one, somehow appending the records
to the global (temp) table before opening the next file...
thanks for any advice,
kz