Import Excel data into multiple tables
Suppose I'have the following Excel file:
![]()
How can I import this information into multiple tables (Projects, Employees, Membership)? I did take a look at the documentation
here, here as well as this question. However, from my understanding this would be better suited for an initial import of data so that the database is set for further use on the database itself.
It is important to note that, per business requirements, this is not a one-off operation as the Excel file must be continually imported to reflect changes. Any ideas would be greatly appreciated as the real file contains 55+ columns and doing things by hand would be time-consuming.
How can I import this information into multiple tables (Projects, Employees, Membership)? I did take a look at the documentation
here, here as well as this question. However, from my understanding this would be better suited for an initial import of data so that the database is set for further use on the database itself.
It is important to note that, per business requirements, this is not a one-off operation as the Excel file must be continually imported to reflect changes. Any ideas would be greatly appreciated as the real file contains 55+ columns and doing things by hand would be time-consuming.
