Importing data in to the Human Resources module in Microsoft Dynamics GP

This article contains more information about importing data in to the Human Resources module in Microsoft Dynamics GP.
Here is a summary of the options:

SQL Server Import:

You can use the SQL Server Import and Export Wizard  to import/append a SQL table from an Excel spreadsheet and this works for HR tables as well. In SQL Server Management Studio, right-click on the company database, and select Tasks and click on Import Data... to open the wizard.

SQL Server Data Transformation Services:

Refer to the KB article below:


Currently an option is to use Table Import to import data into the HR windows. Information on the window may be held in the SDK.
To gather information on importing into Microsoft Dynamics GP, you can reference the below KB article:

KB 856667 - How to use Table Import to import data into Microsoft Dynamics GP


With Microsoft Dynamics GP 2010, you can use eConnect to import limited data into HR using the following Human Resources schemas:

• HRApplicantEducationType
• HRApplicantInterviewType
• HRApplicantReferenceType
• HRApplicantSkillType
• HRApplicantTestType
• HRApplicantType
• HRApplicantWorkHistoryType
• HRCreateSkillSetType
• HRCreateTestType
• HRDeleteApplicantApplicationType
• HRDeleteApplicantEducationLineType
• HRDeleteApplicantEducationType
• HRDeleteApplicantInterviewType
• HRDeleteApplicantReferenceLineType
• HRDeleteApplicantReferenceType
• HRDeleteApplicantRequisitionType
• HRDeleteApplicantTestLineType
• HRDeleteApplicantTestType
• HRDeleteApplicantType
• HRDeleteApplicantWorkHistoryLineType
• HRDeleteApplicantWorkHistoryType
• HRDeleteRequistionType
• HRDeleteSkillSetLineType
• HRDeleteSkillSetType
• HRDeleteSkillType
• HRDeleteTestType
• HRRequisitionType
• HRSkillType

Integration Manager:

Currently Integration Manager does not support importing information/data directly into the Human Resource module. Within IM, there is no destination available for Human Resource as it is considered a 3rd party add-on within the Microsoft Dynamics GP system. Therefore, IM does not have a supported option to bring in transaction data into HR. However, you could use some of the IM features with Payroll to bring in some of the setup information as follows:
  • IM could be used to bring in Employee Master Data directly into Payroll. Human Resources Management reads directly from the Payroll Employee Master data table (UPR00100) from Payroll.
  • The main setup for Benefits and Deductions could be brought into Payroll with IM, and then use the HR Reconcile utility in Microsoft Dynamics GP to bring this setup data over to HR. There are HR Reconcile options for 'Update Benefit Setup' and 'Update Benefit Enrollment' to update HR with benefit/deduction setup and enrollment from the corresponding codes in Payroll. 

More information
import HR data SQL tables directly
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Article ID: 2856302 - Last Review: 10/29/2015 19:59:00 - Revision: 4.0

Microsoft Dynamics GP 2010

  • kbmbsmigrate kbsurveynew KB2856302