Hi Ranjana,
It's all about what you mean by "export" or "import"
If you have a table with project-type data (name, duration, etc.) you can
read it into a Project file using Open in Project and give Access as a file
type.
However, this will only convert the data in the table and store them as such
in Project fields.
Now what you talk about (timesheet type data) is a different animal. The
data have to be added in a well-defined spot in the project file and some
treatment is often necessary.
This is clearly a case for programming logic and VBA is an option (the one I
know best)
Such a program can be written and stored in Access, reading whatever data
you will need; front end, you will have opend the Project application (see
help on the CreateObject function) so you can open the relevant Project file
and address tasks, resource, assignlment objects to update them with the
actual woirk data coming fromp Access.
I've written such programs several times (be it the data came from Excel or
..csv, I do not know Access well) and I want to highlight the fact that it is
not obvious to be sur eto point to the right task/resource combination -
tasks can have duplicate names and they vcan be move such that their ID has
changed.
Hope this helps,
