Import from Excel 2007

Member for

6 years 2 months

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.

Member for

20 years 7 months

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. :)

Member for

20 years 7 months

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.

Member for

20 years 7 months

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--------

Member for

20 years 7 months

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.

Member for

19 years

héhéhéhéhé



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





mimoune

Member for

22 years 9 months

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