Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver 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.

To all Experts

7 replies [Last post]
Tue, 2009-08-04 08:38
moutaz aldeib
User offline. Last seen 3 years 19 weeks ago. Offline
Joined: 31 Dec 2003
Posts: 291
Groups: None
Dear Planners,

I used to produce tabular resourse report by exporting data to excel file using file format WK1 or WKS, but I was shocked when I tried to export data to excel 2007 as the WK1 and WKS formats are not supported by excel 2007.

Is there any one can help solving this problem.

I will be gratefule for that.

Regards,

Moutaz
Top

Replies

Tue, 2009-09-15 08:40
#1
Zq qz
User offline. Last seen 13 years 6 weeks ago. Offline
Joined: 6 Jun 2003
Posts: 163
Groups: None
just use your old method, but instead of WK1....wks....just leave it blank....

oki doki.
Top
Sat, 2009-08-08 08:05
#2
Rafael Davila
User offline. Last seen 1 week 2 days ago. Offline
Joined: 1 Mar 2004
Posts: 5241
Groups: Spider Project Team
moutaz

I had a good experience with Excel; it opened the file with the fields under different cells. Then I could run an Excel filter very easily.

There are many ways to skin a cat, you should use the one best fit you.

Best regards,
Rafael
Top
Sat, 2009-08-08 06:41
#3
moutaz aldeib
User offline. Last seen 3 years 19 weeks ago. Offline
Joined: 31 Dec 2003
Posts: 291
Groups: None
Dear Rafeal,

Thanks so much for your response and your offer.

I managed to open it through DBF, however, the results I got are not the same as I convert it through WK1 and WKS.

Regards,

Moutaz
Top
Wed, 2009-08-05 06:27
#4
Rafael Davila
User offline. Last seen 1 week 2 days ago. Offline
Joined: 1 Mar 2004
Posts: 5241
Groups: Spider Project Team
Moutaz

The DBF format can be read by Excel 2007, just it will not open it automatically.

You have to either:

1) Right click on the dbf file, select open with, and choose Excel.

2) You can set up your system to open DBF file extension with Excel automatically.

You can download the movie, there you will see the file format is in DBF and that it was opened using Excel 2007, you will recognize 2007 ribbon.

To unpack the file you might need some utility like IZArc, you can downoad it from the foloowing link.

izarc.org

I have no much work for the moment so if I can be of any help don’t hesitate to ask for more assistance if you wish.

I am also to try Dieter suggestion as another avilable alternative, although I still believe with a right click and open with Excel saves you a step. Note that the wks conversion utility does not work with Excel 2007, that there will be a stand alone utility but is not avilable yet.

Best regards,
Rafael
Top
Wed, 2009-08-05 05:51
#5
Dieter Wambach
User offline. Last seen 7 years 44 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Moutaz

EXCEL 2007 doesn’t support wks/wk1. The following link contains a freeware:

http://www.rl-software.com/converter/wks-wdb-to-excel.htm

But: I never used it. So I can’t give any information on its liability.

Good luck!

Dieter
Top
Wed, 2009-08-05 04:54
#6
moutaz aldeib
User offline. Last seen 3 years 19 weeks ago. Offline
Joined: 31 Dec 2003
Posts: 291
Groups: None
Dear Rafael,

Thanks for your response.
the DBF format is not supported by excel 2007, consequently can not be opened.

Regards,

Moutaz
Top
Tue, 2009-08-04 09:20
#7
Rafael Davila
User offline. Last seen 1 week 2 days ago. Offline
Joined: 1 Mar 2004
Posts: 5241
Groups: Spider Project Team
When importing it is often easier to work with the DBF format which may be opened with Excel.

Importing/Exporting with the DBF

The following is a screen capture video using DBF format to import and filter relationship lag showing the procedure in action.

Sample Video

Best regards,
Rafael
Top