Split Your Master Data Document for Specific Total Rows

As a routine for go live preparation, you always have a lot of master data to uploaded on the production database. And when you’re using Data Transfer Workbench (DTW), sometimes it will be an error if you use files that have more than 10000 rows on one text files (.txt) So, you need to split your excel files that contains you raw data. We can use Macro feature on Microsoft Excel. On View tab, click on icon Macros. Then, input the Macros name, it’s up to you. After that, just click OK button. Then, open your split query.txt, copy-paste your