Exporting Notes Field to Excel

[Dave A]

Is there any way to export all data from the notes field? When I used the
export tool to export all data to excel much of the data was missing. It
would put "..." after a sentence or two.

 

[John]

Is there any way to export all data from the notes field? When I used the
export tool to export all data to excel much of the data was missing. It
would put "..." after a sentence or two.

Dave,
That is because a simple export takes only 256 characters of the Notes
field. There are a couple of ways to get the entire Notes field
exported. One is to query the Project database directly (i.e. SQL). The
second is to use VBA. If you are interested in the latter, I have a
couple of macros that will do the export for you. If interested, write
me direct.

Hope this helps.
John
Project MVP

 

[Stephen]

I am interested. please post your code or let me know how to contract you.

Regards

Stephen

 

[John]

I am interested. please post your code or let me know how to contract you.

Regards

Stephen

Stephen,
The code is too large to post and I only post the most basic stuff
anyway. "Contract you" sounds promising. Sure, I accept contract work -
it's nice to receive some compensation for my time.

However, I'm sure you meant "contact" (a little proofreading goes a long
way). I assume you are accessing this newsgroup via Google since a
newsreader should already show my contact in the header. Nonetheless,
you may contact me using the following. Just remove obvious redundancies.
mjensenatattheriverdotdotcom.

John
Project MVP