Is it possible to have the queries I have written in developer run in excel? I can connect to the db in excel but I'm unsure of how to find and run the queries.
是否有可能让我在开发人员中编写的查询在excel中运行?我可以在excel中连接到db,但我不确定如何查找和运行查询。
1 个解决方案
#1
0
Check out this page.
看看这个页面。
Once you're able to connect, you should be able to query the database in its native language. Select the Power Query tab, then the drop-down From Database -> From Oracle Database. Simply copy/paste your existing Oracle query into the SQL Statement box and you should be good to go.
一旦能够连接,您应该能够以其母语查询数据库。选择Power Query选项卡,然后选择From Database - > From Oracle Database。只需将现有的Oracle查询复制/粘贴到SQL语句框中,您就可以开始使用了。
In case you don't already have it, Power Query is an add-in for Excel. You can find it here.
如果您还没有它,Power Query是Excel的加载项。你可以在这里找到它。
#1
0
Check out this page.
看看这个页面。
Once you're able to connect, you should be able to query the database in its native language. Select the Power Query tab, then the drop-down From Database -> From Oracle Database. Simply copy/paste your existing Oracle query into the SQL Statement box and you should be good to go.
一旦能够连接,您应该能够以其母语查询数据库。选择Power Query选项卡,然后选择From Database - > From Oracle Database。只需将现有的Oracle查询复制/粘贴到SQL语句框中,您就可以开始使用了。
In case you don't already have it, Power Query is an add-in for Excel. You can find it here.
如果您还没有它,Power Query是Excel的加载项。你可以在这里找到它。