I am trying to download project data via ODBC data source (Oracle Database). I was prompted to use a map to map the table columns to project columns. I would like to be able to filter out unwanted projects by passing some parameters. However, I don't seem to see such option available on the map definition screen. Is there a way to do this via VBA? Or, is it possible to get MS Project to run a SQL against the Oracle database? Thanks Hon -- honm ------------------------------------------------------------------------ honm's Profile: http://forums.techarena.in/member.php?userid=50433 View this thread: http://forums.techarena.in/showthread.php?t=986865 http://forums.techarena.in
Hi Hon, Try posting on the developer newsgroup as this one is closing down. Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful Project information can be seen at this web address:http://project.mvps.org/faqs.htm . Mike Glen Project MVP honm wrote: > I am trying to download project data via ODBC data source (Oracle > Database). I was prompted to use a map to map the table columns to > project columns. I would like to be able to filter out unwanted > projects by passing some parameters. However, I don't seem to see such > option available on the map definition screen. Is there a way to do > this via VBA? Or, is it possible to get MS Project to run a SQL > against the Oracle database? > > Thanks > Hon
