Royal Genes


Safe For Kids





PAF to Excel



Tue, 31 Jan 2006 20:35:22 +0000 (UTC) soc.genealogy.computing
previous


Trefor Jones...
I would like to export a Sorted Individual List from PAF to Excel. I have
tried printing it out and scanning to OCR but the OCR does not seem to want
to recognise columns with gaps in them.

Denis Beauregard...
You can print directly to a text file with PAF...

Any help wpild be appreciated.

Steve Hayes...
I have a proigram that will do that with PAF 2.x (indiv2.dat files) but I
don't know about later versions.


Paul Blair...
Print it out to file as .rtf (there is a Print to file checkbox on the
Print dialog)

You can then manipulate that in Word to make a table. Stick the table
into Excel.


Charlie Hoffpauir...
You could try COPY and PASTE. That works for almost anything you can
display on your screen, ie, if you can generate a report with the data
you want showing on the screen, then COPY (control-C) from PAF and
PASTE (Control-V) into Excel.
Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/


Trefor Jones...
Thanks for your all your suggestions. I eventually found the "Print to file"
checkbox, printed to .rtf, imported it to Excel as a \ delimited file and
globally replaced the "tab". All 500+ names transferred in the time it took
me to scan 1 page!! Cheers all!

singhals...
I'm glad it worked, but at the bottom of PAF 5's custom reports screen,
it does offer to export a comma delimited file for you.
next