Re: Export Project notes to Access or Excel
- From: John <mjensen@xxxxxxxxxxxx>
- Date: Tue, 13 Feb 2007 09:12:18 -0700
In article <39FF216E-3706-4685-B59A-7A10ABF7E273@xxxxxxxxxxxxx>,
kaborka <kaborka@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
John: I have the same problem as the OP. I saved the project to SQL and
found the MSP_Tasks table. The TASK_RTF_NOTES column is in the Image
datatype. I was able to get the RTF by casting the column to varchar(1000).
Unfortunately SQL Reporting Services does not have a text field that will
display RTF. I think Crystal Reports does, but I really don't want to go
there just for this. I don't know Access, but can an Access report display
RTF? Is there any other MS solution that can?
kaborka,
So what is your end goal, not necessarily how you want to get there? To
be honest, even though I described the steps for extracting the RTF data
from a Project database file to jdpeterson, I've never actually written
a full macro to use that method. What I do have however is a VBA macro
that exports the Notes and a few other Project fields to Excel. If you
want more information on that, contact me direct.
John
Project MVP
jensenj6atatcomcastdotdotnet
(remove obvious redundancies)
.
"John" wrote:
In article <10A3554F-C7B1-49C7-8AEC-1F30BC23BFD6@xxxxxxxxxxxxx>,
jdpeterson <jdpeterson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
John,
Messages are undeliverable. Tried jenenj6 and jenj6. Please reply to
jdpeterson2005 atat msndotcomcom. Gotta love them spiders.
Thank you for your quick reply.
I am trying to use the notes field for a list of parts, documents, etc.
for
each task. I also wish to export the information into other programs so I
can
create more user friendly forms than Project can provide.
I tried using the macro listed in 'C:\Program Files\Microsoft
Office\OFFICE11\1033\PJDB.HTM', but it appears to be written for Project
Server. I use Project Standard 2003. The macro couldn't get past the 'Dim
cn
As New ADODB.Connection' line. I don't have a database server, so I
imagine
Project didn't know what to do with this data type.
Though I've programmed in several other languages. I have minimal VBA
experience through creating simple macros.
Thank you for offering to help me with this issue.
jdpeterson,
My bad! I can't even type my own e-mail correctly. The correct address
is below (sometimes I just type too fast).
Actually you CAN use the code you found in the Project database
description file and you do NOT need a server. I'm guessing it didn't
work for you for two reasons. First, you need to save your target
project file in database format (File/Save As and then select Save as
type to be "Project Database"). Second, after you copy the VBA code into
the VB Editor, go to Tools/References and find the reference for:
"Microsoft ActiveX Data Objects x.x Library". Check it and hit "OK". You
will probably also want to send the data to a text file instead of using
the Debug.Print Method, but I guess you could copy and paste the entire
contents of the Immediate window into Word.
If this approach doesn't quite get you there, you can still write me
direct - now that I've given a good address.
John
jensenj6atatcomcastdotdotnet
"John" wrote:
In article <2317BE3C-629A-4890-AE1B-0540D405AA3F@xxxxxxxxxxxxx>,
jdpeterson <jdpeterson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
When I use the export map to save columns, the Notes field is
truncated
to
the first few characters and an ellipsis (...) Does anyone know
another
way
to export Notes?
jdpeterson,
The Notes field when displayed as a column in a view or copied and
pasted to another application will truncate the string at either the
first carriage return or at 255 characters, whichever comes first.
The full Notes string can be exported to other applications with VBA or
SQL. I happen to have a macro for doing the former. If you are
interested, contact me direct at the address below.
John
Project MVP
jenenj6atatcomcastdotdotnet
(remove obvious redundancies)
- References:
- Re: Export Project notes to Access or Excel
- From: kaborka
- Re: Export Project notes to Access or Excel
- Prev by Date: Re: Printing the Gant Chart in 2003
- Next by Date: Re: Circular ref in master projects - Continued
- Previous by thread: Re: Export Project notes to Access or Excel
- Next by thread: Re: VBA for printing Gantt by week
- Index(es):
Relevant Pages
|
