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?