I find ASCII .PRN files work, just be careful when setting the column widths. Depending on how you've been managing these files todate you could: double-click the .PRN file which will either prompt you to choose which application to use to open the file (Excel) then follow the wizard to format data columns OR it will open immediately, although in the latter the P3 column data fields will appear in one column - if so separate them using various Excel funtions to get the data into the desired format, (LEFT, MID, RIGHT, TRIM) - I use a template for this.
.WK1 files follow the same processes as above. However, beware they will only accept the first 2048 data rows, so .PRN is generally more reliable.
Hope this helps
Andrew
Member for
24 years
Member for24 years1 month
Submitted by Daniel Limson on Tue, 2010-10-05 04:23
P3 is an old software running on 16 bit and no longer compatble with the latest softwares available in the market. They already stopped developing this software 7-8 years ago. The things I used to do to make my life easy no longer functions even a simple conversion to PDF file, you need an old version of adobe or you can use cute pdf converter. The process that Shareef mention above may work, you can maybe export it but importing back the file does not work either. So my advice is to move or switch to P6.
Best regards,
Daniel
Member for
20 years 1 month
Member for20 years1 month
Submitted by Shareef Abdul Azeez on Mon, 2010-10-04 21:25
Member for
19 years 3 monthsThanks guys, I will try this
Thanks guys, I will try this out.
I know P3 is very outdated, I personaly use P6 & P3.1, the problem is that some of our clients still wants P3 to be used.
Member for
19 years 3 monthsThanks guys, I will try this
Thanks guys, I will try this out.
I know P3 is very outdated, I personaly use P6 & P3.1, the problem is that some of our clients still wants P3 to be used.
Member for
22 years 5 monthsP3 to Excel 07/10 data transfers
Hi Michael,
I find ASCII .PRN files work, just be careful when setting the column widths. Depending on how you've been managing these files todate you could: double-click the .PRN file which will either prompt you to choose which application to use to open the file (Excel) then follow the wizard to format data columns OR it will open immediately, although in the latter the P3 column data fields will appear in one column - if so separate them using various Excel funtions to get the data into the desired format, (LEFT, MID, RIGHT, TRIM) - I use a template for this.
.WK1 files follow the same processes as above. However, beware they will only accept the first 2048 data rows, so .PRN is generally more reliable.
Hope this helps
Andrew
Member for
24 yearsP3 vs. Excel 2007/2010
Hi Michael,
P3 is an old software running on 16 bit and no longer compatble with the latest softwares available in the market. They already stopped developing this software 7-8 years ago. The things I used to do to make my life easy no longer functions even a simple conversion to PDF file, you need an old version of adobe or you can use cute pdf converter. The process that Shareef mention above may work, you can maybe export it but importing back the file does not work either. So my advice is to move or switch to P6.
Best regards,
Daniel
Member for
20 years 1 monthHi Michael
I am not aware of excel 10 but with excel 07 you can use .dbf file
.csv file is not compatible.
Even with .dbf file it does not open directly.
You will have to open excel first and then drag and drop the .dbf file onto the open excel window.
Hope this helps
Best Regards
Shareef A Azeez