I have a business that has over 3,500 temporary employees that come and go throughout the year. I track lots of this employee information in an separate access database and this year I am trying to integrate tighter into QB so the staff does not have to do double entry. Therefore, I really want to put all of the employee information from my access database into QB. I have figured my best chance of doing this is using is direct table access with ODBC…..Why? SDK is slightly out of my league and it appears that importing employee information is really only available with IIF (which apparently is no longer supported???). Anyway, with that background in place, let me ask a couple of questions (hopefully I didn't miss this information in some piece of documentation):
Question #1 - Some of the table data does not appear to be exposed to ODBC, is that correct? For example, I would like to import Emergency Contact Information (which is available to type in in the qb ui), but it doesn't appear to be in the Employee table nor could I find it in any other table. There is other information like this as well I9, Work Authorization expiration, etc.
Question #2 - Are there certain rules to entering an employee other than fields I see in the Employee table? For example, I see a table called Entity that apparently lists the persons name in there too. If I am entering an employee, do I also need to insert a record into that table too? If so, what other tables are important to insert information into when it comes to creating a new employee record.
Thanks in advance for any assistance.