Project Notes data

[Rod Snyder]

I am trying to extract Notes data from a Project into either a
text-delimited file or Access database. When creating the map in project to
do this, the data type that is assigned to the Notes field is either text or
varchar, which only allows me to export 255 characters from the Notes field.
I need for the data type to be Memo so that all the information being stored
in the Notes field exports to the file or database. I have not been able to
figure out how to change the file type when creating the map. Is there a
way, or will I need to create a stored procedure to define the data field
type and extract it directly from the SQL server?

Rod

 

[John]

I am trying to extract Notes data from a Project into either a
text-delimited file or Access database. When creating the map in project to
do this, the data type that is assigned to the Notes field is either text or
varchar, which only allows me to export 255 characters from the Notes field.
I need for the data type to be Memo so that all the information being stored
in the Notes field exports to the file or database. I have not been able to
figure out how to change the file type when creating the map. Is there a
way, or will I need to create a stored procedure to define the data field
type and extract it directly from the SQL server?

Rod

Rod,
Notes text beyond 255 characters cannot be exported via an export map.
Getting the full notes text requires the use of either VBA or a direct
query to the Project database.

I have a couple of VBA macros that export Notes text to Excel using VBA.
If you are interested contact me direct and I'll give you more
information. The code would need to be modified to send the info
directly to a text file or other application (e.g. Access). If you do
not have VBA experience, you could do a query with SQL. For information
on the Project database structure (Notes text is stored as RTF), look
for the projdb.htm document, (or similar depending on what version of
Project you are using), on your hard drive.

Hope this helps.
John
Project MVP