Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

Import from Excel 2007

8 replies [Last post]
Tue, 2007-01-30 05:36
Taqi Hasan
User offline. Last seen 3 years 52 weeks ago. Offline
Joined: 26 Jan 2003
Posts: 11
Groups: Petro-Chem / Oil & Gas
Hi Every1!,

It seems Excel 2007 does not allow documents to be saved as wk1 or dbf formats. Is there any method to resolve this issue? In my computer i have installed "Open Office" from where i am able to convert xls files into wk1 files.. Thanks in advance.
Top

Replies

Thu, 2019-08-29 14:16
#1
Zoltan Palffy
User offline. Last seen 4 weeks 1 day ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

as a work around you can install open office for free it supports opening and saving in the dbf format

here is the link

https://www.openoffice.org/

Top
Sat, 2019-08-24 13:48
#2
Susanna Kate
User offline. Last seen 4 years 3 weeks ago. Offline
Joined: 20 Aug 2019
Posts: 14
Groups: None
Follow the following steps:
  1. In Microsoft Project, go to File | Open.
  2. Change the Files of Type combo box to Microsoft Excel (*.xlsx).
  3. Select the extract file and click Open.
  4. Click the Next button.
  5. Select Use Existing Map.
  6. Select the Excel MPP map.
  7. Select Append the Data to the Active Project

Hope it helps.

Top
Wed, 2007-01-31 04:36
#3
Gün Göksu
User offline. Last seen 1 year 40 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 123
Groups: GPC Qatar, Petro-Chem / Oil & Gas, TILOS
Somebody please check if the "Office file converter pack" (OCONVPCK.EXE) found under download.microsoft.com works for excel 2007.
it says nothing for excel 2007.

Thank you.
Gün. :)
Top
Wed, 2007-01-31 03:27
#4
Gün Göksu
User offline. Last seen 1 year 40 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 123
Groups: GPC Qatar, Petro-Chem / Oil & Gas, TILOS
hello again,

sorry I cant find the addon. I probably have misread the download microsoft offers for office2003 users to open and save office2007 files.

I suggest you try opening the file via odbc into excel.
It should work. you may need an odbc driver though.

I am downloading an excel2007 trial version now to try it out.
hope it does not mess up my office2003.

will post info as it comes up.

Gün.
Top
Wed, 2007-01-31 02:45
#5
Gün Göksu
User offline. Last seen 1 year 40 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 123
Groups: GPC Qatar, Petro-Chem / Oil & Gas, TILOS
here is it:

the following was taken from microsoft’s excel blog.
blogs.msdn.com/excel/archive/2006/08/24/718786.aspx

title of post is: Deprecated features for Excel 2007
--------snip--------
File Format Support

Historically Excel has supported many different data formats. We have determined that a number of these older formats are seldom, if ever used. We are removing support for some file types to allow us to devote more of our efforts towards the file formats that are being used. Theses formats are being deprecated in 2 ways. For the set of file formats with the lowest usage, we will be discontinuing support for opening and saving of these formats. For the second set that has some minimal usage, we will support loading the files in Excel 2007 to allow you to save them in a newer format.

The following formats cannot be opened or saved in Excel 2007:

* WK1 (1-2-3)
* WK4 (1-2-3)
* WJ3 (1-2-3 Japanese) (.wj3)
* WKS (1-2-3)
* WK3,(1-2-3)
* WK1,FMT(1-2-3)
* WJ2 (1-2-3 Japanese) (.wj2)
* WJ3, FJ3 (1-2-3 Japanese) (.wj3)
* DBF 2 (dBASE II)
* WQ1 (Quattro Pro/DOS)
* WK3,FM3(1-2-3)
* Microsoft Excel Chart (.xlc)
* WK1,ALL(1-2-3)
* WJ1 (1-2-3 Japanese) (.wj1)
* WKS (Works Japanese) (.wks)

The following formats may be opened, but not saved to in Excel 2007:

* Microsoft Excel 2.1 Worksheet
* Microsoft Excel 2.1 Macro
* Microsoft Excel 3.0 Worksheet
* Microsoft Excel 3.0 Macro
* Microsoft Excel 4.0 Worksheet
* Microsoft Excel 4.0 Macro
* Microsoft Excel 97- Excel 2003 & 5.0/95 Workbook
* Microsoft Excel 4.0 Workbook
* DBF 3 (dBASE III)
* DBF 4 (dBASE IV)
--------snip--------
Top
Wed, 2007-01-31 02:34
#6
Gün Göksu
User offline. Last seen 1 year 40 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 123
Groups: GPC Qatar, Petro-Chem / Oil & Gas, TILOS
hello.

I suggest you take a look at www.openoffice.org

its opensource, very flexible, very complete.
it has some good addons too.

the menu’s are nearly identical to M$’s.
opens xls and doc files like M$’s.

it works like you want it to. no fiddling behind your back.
you can modify the source or add to it like you want.

and it can run through a usb flash disk with very minimal twinkling. so you dont have to run an install to use it (search google).

imagine having excel, word, access, web integration, powerpoint, picture editor, and all the rest in your flash drive ready to run anywhere. Its done.

sorry, its freeware, and i am not affiliated to it.

Gün.

ps: as for excel2007 I think I remember that there was an addon on microsoft’s site to add backward functionality (old discontinued formats re add). will do a search and post the link here.
Top
Tue, 2007-01-30 09:15
#7
mimoune djouallah
User offline. Last seen 4 years 40 weeks ago. Offline
Joined: 14 Oct 2006
Posts: 388
Groups: Petro-Chem / Oil & Gas, Spider Project Team
héhéhéhéhé

God bless Sun God bless open source; my friend it is a only a matter of time


mimoune
Top