Import definitions and importing
DB tool > Functions tab > Import menu > Import definition management
You can add all the links between the source and the project tables in an import definition, and then import data to the project database. You can import data from Excel, Access and XML files (.xsl, .xslx, .xlsm, .xlsb, .xlt,.xltx, .xltm, .mdb, .accdb, .xml).
The data is imported with the Import function according to the import definition.