Skip to content

Import from Excel 2007

Taqi HasanMember for 23 years 8 months
Created
8
3
0
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.

8 replies

Oldest first
  1. 0
    Alexandre Faulx-Briole ·
    Hi Taqi Hassan
    are you sure that Excel 007 does not need an additional filter to be installed to read/write wk1 files?
    it would work with Custom install
    Cheers,
    Alexandre
  2. 0
    Mimoune Djouallah ·
    héhéhéhéhé

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


    mimoune
  3. 0
    Gün Göksu ·
    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.
  4. 0
    Gün Göksu ·
    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--------
  5. 0
    Gün Göksu ·
    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.
  6. 0
    Gün Göksu ·
    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. :)
  7. 0
    Susanna Kate ·

    Follow the following steps:In

    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.

  8. 0
    Zoltan Palffy ·

    as a work around you can

    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/

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?