Question $3$ of $51$

Points: $1$

How can a user import multiple Excel files at once if each file has a different schema?

A$.$ Use a wildcard $(*)$ in the sheet name when using the Input Data tool.

B$.$ Import only the list of sheet names using an Input Data tool followed by a Dynamic

Input tool and choose to change the File$/$Table Name.

C$.$ Create a Batch Macro and adjust the settings in the Interface Designer to Auto

Configure by Name.

D$.$ Select "Output File Name as Field: Yes and Import only the list of sheet names" using

an Input Data tool followed by a Dynamic Input tool and choose to change the

File$/$Table Name.

Clear selection