Twin access DB synching

[Martin Teefy]

Hi,

Any advice on how to copy some tables/data out of one access db to update
another bigger central db ?

Via some VB accessing Access properties or just creating CSVs to read and
SQL update against second database ?

Thanks

 

[Arvin Meyer]

From the larger database you can run an append query which will get the data
out of another database and append it to your table. For instance this is a
working query:

INSERT INTO tblNGTest ( PersonID )
SELECT qryAddresses.PersonID, *
FROM [G:\SampleData.mdb].qryAddresses
WHERE (((qryAddresses.PersonID)=5));

Notice how the From clause is written. The full path and name of the outside
database is enclosed in square brackets. The G:\ drive is a mapped network
drive.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access