Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

P3 export to Excel 2007 - wks or wk1 not readable

15 replies [Last post]
Wed, 2007-07-25 03:13
Charleston-Joseph...
User offline. Last seen 3 years 17 weeks ago. Offline
Joined: 10 Jul 2005
Posts: 1347
Groups: None
Hello to all,

I’m using MS Office 2007, excel 2007.

When I export P3 to excel 2007, i cannot open the exported file in normal way. The file got funny characters.

I found out that excel 2007 cannot read .wks or .wk1. This happen to you also.

Is there some secret way for excel 2007 to read .wks or wk1, similar to excel 2003 or lower version.

Please advice.

Cheers,

Joseph

Top

Replies

Mon, 2007-07-30 04:00
#1
Charleston-Joseph...
User offline. Last seen 3 years 17 weeks ago. Offline
Joined: 10 Jul 2005
Posts: 1347
Groups: None
Uly,

Monopoly????

In US of A, anti trust is very strong. It is not tolerated to monopolize anything. Microsoft learned this lesson long time ago. It is also one reason why BG as in Bill Gates minimize his involvement in Microsoft because of his apetite to monopolize the software industry.

Maybe it is more on "CONSPIRACY THEORY". Conspiracy between Primavera and Microsoft.

Any idea??????

Cheers,

Joseph
Top
Sun, 2007-07-29 04:55
#2
ulysses garcia
User offline. Last seen 13 years 42 weeks ago. Offline
Joined: 22 Aug 2005
Posts: 259
Groups: GPC Qatar
Primavera is a rival of MS project, in my opinion whatever advantage MS think to thier company they will do it, the term..
Monopoly......
Top
Sun, 2007-07-29 04:46
#3
Charleston-Joseph...
User offline. Last seen 3 years 17 weeks ago. Offline
Joined: 10 Jul 2005
Posts: 1347
Groups: None
Hi Man,

Uly read the thread.

As per someone, Microsoft REMOVE the functionalities of the old programme (WKS & WK1) in excel 2007. Take note that this is P3 export and import in excel 2007.

So it is very clear that no way we can use p3 export / import functionalities in excel 2007 the way we use to be in previous excel version. AGREE???????

What we need here in planning planet is to petition Microsoft to reinstate WKS & WK1 Functionalities in excel 2007.

In this way, it will be easy for us to use excel 2007 in doing p3 work export / import function.

Think about it. there are almost 20,000 PP members. Can we make a lot of difference to microsoft. How about the others outside PP, there are lots of planners maybe millions suffering because Microsoft remove the wks and wk1 functionalities in excel 2007.

In my previouse post, i really do not have problem yet in using P3 export / import because I can still used excel 2003 and excell 2000.

Cheers Man,

Joseph
Top
Sun, 2007-07-29 04:44
#4
DATTATREYA PADHARTHI
User offline. Last seen 5 years 51 weeks ago. Offline
Joined: 18 Apr 2003
Posts: 90
Groups: Petro-Chem / Oil & Gas, Regional Representatives
Charleston,

Try using MS access 2007 after exporting the dbf file thru P3, You can open & save in dbf3,4 or 5 & do all your updations.

Cheers

Dattatreya
Top
Sun, 2007-07-29 04:32
#5
ulysses garcia
User offline. Last seen 13 years 42 weeks ago. Offline
Joined: 22 Aug 2005
Posts: 259
Groups: GPC Qatar
Charlestn,

It seems to me you are very expert in planning , as i notice in some of your reply,.

But your question now is just for a young BABY planner.
HOW comes, chap. Dont be boastful too much.. becuase you need also some help for some young planner.ok chap, next time be cool , dont be hostile

From all Planners
Top
Sun, 2007-07-29 04:23
#6
DATTATREYA PADHARTHI
User offline. Last seen 5 years 51 weeks ago. Offline
Joined: 18 Apr 2003
Posts: 90
Groups: Petro-Chem / Oil & Gas, Regional Representatives
Dear Garcia,

With due respect, many companies are still using P3.1 & P6 is not in the market as of now.
Yes companies should upgrade to P5.0 , but not many companies are willing to invest, so its the same old P3.1 which can be used as effectively as possible with its limitations.

You can always use the RA engine & get/set everything in P3 (Import & export) in excel,access etc.

Cheers
Dattatreya
Top
Fri, 2007-07-27 09:04
#7
Andrew Podolny
User offline. Last seen 1 year 19 weeks ago. Offline
Joined: 16 Nov 2004
Posts: 130
Groups: Petro-Chem / Oil & Gas
You can use Calc (which is similar to Excel) from Sun.
Just go to www.openoffice.org and download the package.
It can handle DBF / WKS and It’s free.
Regards,
Andrew
Top
Fri, 2007-07-27 23:38
#8
ulysses garcia
User offline. Last seen 13 years 42 weeks ago. Offline
Joined: 22 Aug 2005
Posts: 259
Groups: GPC Qatar
I do not know, why you are having headache using P3, There are P5, P6 use it is more practical than P3; is considered as unripe tool and not fully develovep..
I considered P3 is good if i cant find anyone like P5,P6..
Top
Wed, 2007-07-25 20:55
#9
DATTATREYA PADHARTHI
User offline. Last seen 5 years 51 weeks ago. Offline
Joined: 18 Apr 2003
Posts: 90
Groups: Petro-Chem / Oil & Gas, Regional Representatives
You can always export in DB4 & open in excel 2007.
But cannot import since Excel 2007 cannot save in dbf which was possible in 2003 version.
This makes automation difficult.
Top
Wed, 2007-07-25 06:47
#10
Swapna Boinpally
User offline. Last seen 17 years 14 weeks ago. Offline
Joined: 5 Jul 2007
Posts: 12
Groups: None
I don’t know if this would help you, but have you tried exporting it in the database format(.DBF)?
Top
Wed, 2007-07-25 05:49
#11
ulysses garcia
User offline. Last seen 13 years 42 weeks ago. Offline
Joined: 22 Aug 2005
Posts: 259
Groups: GPC Qatar
MS office 2007 are intended for vista windows, in this case p3 ,using such new version for ms office will not work well..
I guess that primavera wants to erradicate p3 and encourage to use p5
Top
Wed, 2007-07-25 05:37
#12
Charleston-Joseph...
User offline. Last seen 3 years 17 weeks ago. Offline
Joined: 10 Jul 2005
Posts: 1347
Groups: None
Thanks Brad,

Actually, I have three laptops, 2 laptops i personally own, the other laptop was company provided.

The company provided laptop got P3 and office 2007.

The other laptops got office 2003 and office 2002. I can still export/import using my laptops, P3, Office 2003 or Office 2002.

But, I want to know the tricks using P3 and excel 2007.

Please advice.

Cheers,

Joseph


Top
Wed, 2007-07-25 04:39
#13
ulysses garcia
User offline. Last seen 13 years 42 weeks ago. Offline
Joined: 22 Aug 2005
Posts: 259
Groups: GPC Qatar
P3 now using new feature in mswin will not work will.
Top
Wed, 2007-07-25 03:36
#14
Brad Lord
User offline. Last seen 10 years 24 weeks ago. Offline
Joined: 27 May 2003
Posts: 256
Groups: None
if you email me the file will save it as an excel format for you

bradley.lord@jarvis-uk.com

regards

Top