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

M

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.

a

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.