load multiple tables in a single load statement

[#1]

Hi Good Evening,

Could you please answer me any one.

How to load multiple tables in a single load statement?

[sinanozdemir]

It is a vague question, but I will do my best to elaborate:

If you are pulling data from a SQL database, you can pick ODBC (is strictly for relational databases) or OLE DB (is not strictly for relational databases, it is for SQL, Access and Excel files as well). Once you choose an ODBC connection, you click "Select" to start building your SELECT statement. If you want to pull data from a different server/database, you follow the same steps.

For Excel files, you can use "Table Files" options, as many times as you would like to import Excel files from different directories on your computer.