Can I import data from excel into project

[Tony F]

I need to import selective data from an oracle data base into MS Project.
This information is downloadable through an interface that will dump it into
an Excel spreadsheet. It is just raw data. I need it formatted properly for
MS Project (with indentions and links). What are my options? I could possibly
have the data sent to me in a different way (from the data warehouse). I need
guidance. Could I create a template in project that would contain the correct
format? Could I take the data directly to Project with out the Excel step?
Any ideas?

 

[Brian K - Project MVP]

I need to import selective data from an oracle data base into MS Project.
This information is downloadable through an interface that will dump it
into
an Excel spreadsheet. It is just raw data. I need it formatted properly for
MS Project (with indentions and links). What are my options? I could
possibly
have the data sent to me in a different way (from the data warehouse). I
need
guidance. Could I create a template in project that would contain the
correct
format? Could I take the data directly to Project with out the Excel step?
Any ideas?

Export a project with links and indentations and then export it to Excel.
Export Tasks, Resource and Assignments.

Then look at the spreadsheet it creates. That is how it should look.