Newbie Question

[gblaxx42]

I created a DB to track soldier information. Each month reports are due to
Brigade. Each Company and Battalion has there own version of the DB. What I
need to do is export data from the Company then import it to the Battalion.
Then I need to export the info from the Battalion and import them into the
Brigade. This information is either all new for a new soldier or updated info
for an existing record for an existing soldier. I need to update all new
changes to the info. What is the best method for doing this.

Also, when I try to export a .dbf, it pops up with an error saying there are
duplicate field names. Im confused because ieach field name is unique.

Thanks for any help I can get.


Lt Butler

 

[Klatuu]

First, thanks for your service to the country.

I would export the data to a csv file and send that to where it needs to go.
Then at the receiving unit, link to the csv file as if it were a table using
the TransferText action or method. It would be beneficial if you set up an
import specification for the file. Then create update queries to update the
existing data. An Update query will also add any new records to the Access
tables.

As to the dbf file, I can't say what may be causing the problem. How are
you doing the export?