Microsoft Excel Power Query

Highlighted
Occasional Visitor

A company has approx thousands of branches around the country. The company uses a web-based application for data input and for the reports; in oracle based system, which generates reports in Microsoft Word RTF format. Could all the branches be able to get the reports in excel directly from the software into Excel Power Query?

 

Branch offices are needed to supply username and password while logging into the software online.

 

Different types of reports (daily, weekly, monthly, and yearly) are needed to download from the software, if could load those reports directly into Excel Power Query it would help to automate the task to some extent.

0 Replies