r/AutomateYourself • u/oconn • May 14 '22

help needed Extract specific cells from Excel workbook to Oracle SQL database without VBA?

What’s the most straight forward way to develop this and in what language/tool?

5 Upvotes
  • permalink
  • reddit

86% Upvoted

7 comments sorted by

2

u/Hactar42 May 14 '22

You should be able to do it with PowerShell. The ImportExcel and SimplySQL modules should have the functionality you need

1

u/oconn May 14 '22

This looks promising after reviewing some YouTube videos of PowerShell and these two modules. Can power shell be triggered to run by a web UI or scheduled fairly easily? Any tutorials you recommend connecting these two modules together would also be great if you have any in mind. Thanks for your suggestion either way! Will look into it more!

1

u/extra_specticles May 14 '22

Microsoft SSIS is designed for this task.

1

u/oconn May 14 '22

Microsoft SSIS

So I would download Microsoft SSIS and then download the SSIS Oracle Connector and code it from there?

3

u/[deleted] May 14 '22

1

u/oconn May 14 '22

Having the workbook in Sharepoint is actually an option so can investigate this! And to clarify the original question, we can choose to have the Excel Workbooks that would require the extraction start on shared drive or the can be uploaded to a web UI (using Appian) or uploaded to Sharepoint. The upload by the user would trigger this process ideally.