Append data automatically

[wilsjohnc]

I have excel file generated daily basis. Need to get data from daily generated file automatically. Tried table.insertrows but its giving error. Is this correct function or any other way to do this. Please try to explain in detail.

[artemus]

Normally every time you refresh the data set it load the entire data set again.

If you want to append two tables together you can:

Table1 & Table2

Or if you have a bunch of tables to append you can:

Table.Combine(listOfTables)