For the life of me I can't remember how this is done. I have an excel file as destination and want to create table from it dynamically. Funny thing is I was messing around with it yesterday and it somehow created a sql script to create the table. I don't know what I done so can't replicate it and have had to do a bit of a rebuild since and removed a lot of the workflows.
I have 4 tables/4 sheets to create. There is potential for the Excel files to be changed, i.e. new columns etc. so want to have it dynamic, although if it picked up changes it would be overwriting the table with all data in it, so not sure maybe this is best idea going forward, but want to at least be able to do it first run.
Thanks fo any useful info.