Filling up linked tables after importing external data

[kvpassel]

Hi all,

Background of this project is a database to aid HR instead of having them update a dozen of excel documents each time.

This is my current situation:

I'm importing data from a Word Form file using VBA and placing in into a table that does nothing except holding the imported data. The Word file is filled in by the employee with most of his personal data and should get loaded into the DB each time a new employee starts or some of his "data" changes.

This data should get distributed over several tables.
The main table which links all of them together is "Employee". This also holds foreign keys to a table "Address", "Partner" and several others.

Can you guys advice me on the best practice to add/update the records to the appropriate tables once the import has added the record to the import table?

Thanks in advance!

If you need more info, just ask.
And if it's in the wrong board, could one of the admins move it? I wasn't sure between this one and the VBA board, since both are applicable.

 

[Dhamdard]

I would suggest that you create append queries from the main 'employee' table to each of the sub tables. And then create a macro/vba code that runs all these queries. After this, add this macro/vba function to the button that imports data to 'employee' table. This means, after successful import, the database will run the append query.