Welcome and thanks for your question.
Check out these videos first and let us know how you do:
Technically, you don't have to write any script, the product's wizards will do it for you.
Let us know how you do:
Main Index: New to Qlik Sense Videos
Data Loading https://community.qlik.com/docs/DOC-6932#dataloading
- Data Load Editor - Loading OLE DB Data (video)
- Preparing Data Part 1 and Part 2
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.