Task Notes do not appear in database

[DavidC]

Hi,

I have a routine which first exports tasks and Unique ID
to a spreadsheet, then in another column the user can
write in notes against a task. I then run another routine
which looks as the value in the 'notes' cell for a task
and places that value into the task notes field in a
project saved as a database. The reason for the database
is to enable a specific report to be written.

using

t.note=excelnote

where t is defined as a task.


When I then run the report in Access I noticed that whilst
the notes appear in MSP_TASKS(TASK_RTF_NOTES), the cut
down version does not appear in the custom text field in
the MSP_TEXT_FIELDS table.

If I first run the routine above into an .mpp file and
then save that file as a database then the notes do appear.

I know the simple answer is to do just that, place the
notes into an .mpp file, and then save as an .mdb file,
but I would like to streamline the whole operation and
work only with the .mdb file.

Does anyone have any ideas on how to place the notes from
excel into the .mdb file such that they appear in the
TASK_TEXT_FIELDS table as well?

The other option is to write the notes in access, but when
I convert them to Long binary data, this time Project does
not see the notes even though they exist.

Perhaps an idea on solving that one might be the way to go.

Ta in advance

Regards

DavidC

 

[Rod Gill]

Hi,

Search for the file projdb.htm in one of project's program folders. All
answers about .mdb table structure are there.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[DavidC]

Rod,

Thanks for that. By the way I have been trying to phone
you most days this past week and left a message on your
phone. I would like to discuss costs etc re some of this
stuff I am trying to do.

Regards

DavidC