andrewaldrich
Registered User.
- Local time
- Yesterday, 18:08
- Joined
- Jan 15, 2012
- Messages
- 17
Could use a quick response on this one ...
I have an Employee Records table with 29k records that I originally imported from an HRIS system. Lets call this table ORIGINAL table.
Each week I export a new Employee Records table from the HRIS system as it contains the latest updated information. IE - New hires, terminations, rate changes, etc. Lets call this table NEW table. It likely contains new records as well as we hire 100+ people per week.
In the ORIGINAL table, I have added fields that are not included in the NEW table. I need to update the records / fields in the ORIGINAL table with the NEW table, but need to keep the ADDED fields.
Originally my plan was just to overwrite the ORIGINAL table with the NEW table until I added the additional fields to the ORIGINAL table.
Any ideas, thoughts, workarounds?
I thought that I could export the added fields in the ORIGINAL table, import the NEW table, and run and update query based on the EE ID#.
I have an Employee Records table with 29k records that I originally imported from an HRIS system. Lets call this table ORIGINAL table.
Each week I export a new Employee Records table from the HRIS system as it contains the latest updated information. IE - New hires, terminations, rate changes, etc. Lets call this table NEW table. It likely contains new records as well as we hire 100+ people per week.
In the ORIGINAL table, I have added fields that are not included in the NEW table. I need to update the records / fields in the ORIGINAL table with the NEW table, but need to keep the ADDED fields.
Originally my plan was just to overwrite the ORIGINAL table with the NEW table until I added the additional fields to the ORIGINAL table.
Any ideas, thoughts, workarounds?
I thought that I could export the added fields in the ORIGINAL table, import the NEW table, and run and update query based on the EE ID#.