|
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
|