Twin access DB synching

M

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
 
A

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
 
Top