P3 vs. Excel 2007/2010

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

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

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 

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.