Help with Datatable[]

I am writing a program which compares many excelsheets (up to 500) with each other. To each of these tables a new one is to be created which can contain data from several of the read in tables.

I need help to initialize the array.Maybe I can better use a list. I have not worked with that yet.

The number of tables to read in is variable. The tables all have a fixed header but a variable number of entries.

the new datatable within the array/list would then be extended with the command merge datatable

i hope that i have described a problem in an understandable way :slight_smile: