Incoming ODBC link from Excel

[Mratko]

This question is the "other side of the coin" to other ODBC questions I have
found. We would like to use an Excel file to create new entries into a
production schedule.
Is it possible? I don't use Project (yet) and will apologize now if it is
evident in the program. The current users don't know.

Thank you in advance for your assistance.

Mike

 

[JulieS]

Hello Mike,

Yes. You can import data from an Excel file and create tasks and
resources. I'd suggest taking a look at the structure of an
existing Project file, and perhaps testing by exporting data to
Excel first to help understand the data structure.

But, the short answer is yes.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[Mratko]

Julie,

Thank you for the timely response and excellent suggestion about the file
and record structure. I will be getting started on this project right after
the New Year.

Happy Holidays and thank you again.

Mike

 

[JulieS]

You're most welcome Mike and thanks for the feedback. Enjoy the
holidays and do post back in the New Year should you need some
additional help.

Best,
Julie