2 Replies Latest reply: Dec 12, 2016 12:31 PM by Caio Lobato RSS

    Loading all sheets from an Excel file

    Caio Lobato

      Hi guys,


      I need to load every sheet from this excel file. Each sheet is a week of the month, this specific file attached is only the data from October (each month has a specific file with the same layout).


      I wanna know if there is some way that make the data load process automatic, I mean no need of a lot of script for each week(sheet), also there is the possibility that the sheet names change for a specific month.


      Using the command SQLtables and a for-loop maybe this can help me, but I did not get a positive result yet.


      Someone have this solution or a better idea? Or is not possible to do that?