Export table to DBF in Access using VB

[james]

I want to combine the contents of a table that exists in 10 databases
(the DBs are the same, data is input into each one on separate
computers, then they must be synchronised).

The only way i could think to do this was to export the necessary table
in DBF/CSV, then import into a master table which lies in a new Access
database.

Firstly, if it is possible to do this easily, tell me please!
Otherwise, how would i export a table to DBF programmatically (using
VB)?

Thanks!

 

[John Vinson]

I want to combine the contents of a table that exists in 10 databases
(the DBs are the same, data is input into each one on separate
computers, then they must be synchronised).

The only way i could think to do this was to export the necessary table
in DBF/CSV, then import into a master table which lies in a new Access
database.

Firstly, if it is possible to do this easily, tell me please!
Otherwise, how would i export a table to DBF programmatically (using
VB)?

Thanks!

See the VBA help for TransferDatabase.

However, this will NOT be an easy way to synchronize the databases!
You may want to look into "Replication". It's complex, but it's
designed to do exactly this.

John W. Vinson[MVP]

 

[james]

alas, i feared as much.

thanks!

 

[John Vinson]

alas, i feared as much.

thanks!

It sort of depends on the data. If you do not have an autonumber
Primary Key, and if there is no chance that different users will
insert or update the same record, then exporting a dBase (or text)
file, linking to it, and Appending it into a master table can work and
maybe not be all that much of a hassle.

If you have Autonumbers, linked tables, duplicate records,
*almost*-duplicate records, etc. it can be an utter nightmare.

John W. Vinson[MVP]