自动从Oracle导入数据到项目 [英] Automate Data Import From Oracle to Project

问题描述

我正在寻找一些示例VBA脚本，这些脚本将帮助我将基于SQL查询的一些oracle数据导入MS Project中的甘特图视图。目标：我真的想要单击功能区上的按钮并使其与Oracle数据库查询连接，在刷新期间显示
状态栏并更新MS Project Gantt图表视图中的数据。

Hi, Im looking for some sample VBA scripts that will help me import some oracle data based on a SQL query to the Gantt chart view in MS Project. Goal: I really want to click a button on the ribbon and have it connect with an Oracle database query, show a status bar during the refresh and update the data in MS Project Gantt chart view.

帮助/建议赞赏。

谢谢

推荐答案

没有办法从Oracle的SQL查询中将数据导入Project。但是，您可以开发VBA代码来执行此操作。这并不简单，但只要您的Oracle数据与Project中的数据轻松匹配，就可以轻松完成。如果没有
一些样本数据，则无法进一步评论。很可能你需要付钱给别人为你开发这个。

There isn't a way to import data into Project from a SQL Query in Oracle. You can however develop VBA Code to do this. It's not simple but it is easily done provided your Oracle data has an easy match to data in Project. Can't comment any further without some sample data. Most likely you need to pay someone to develop this for you.

你需要提供一个很好的样本数据集，可能在Excel中开始，然后暂时提供外部访问以允许调试要从Oracle中读取的代码。

You will need to provide a good sample set of data, probably in Excel to begin with then provide external access temporarily to allow debugging of the code to read from Oracle.

这篇关于自动从Oracle导入数据到项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！