Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 - Import XML
Hi, I have Excel 2003 (11.8307.8221) SP3
I am using a book to learn more advanced options. The book says I should be able to point to the Data menu and choose XML in order to import XML files. I went to the Excel help, which told me the same thing. However, my Data menu has no XML option. Is there something I have to load? Thank you. Karin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 - Import XML
XML not included in default menu.
ToolsCustomizeCommandsData. Scroll down to bottom and you will find some XML commands which you drag up to Data menu or place on a New Toolbar. Gord Dibben MS Excel MVP On Tue, 11 Aug 2009 12:33:02 -0700, Karin wrote: Hi, I have Excel 2003 (11.8307.8221) SP3 I am using a book to learn more advanced options. The book says I should be able to point to the Data menu and choose XML in order to import XML files. I went to the Excel help, which told me the same thing. However, my Data menu has no XML option. Is there something I have to load? Thank you. Karin |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 - Import XML
Thank you - however, there is nothing in the list of commands under Data with
XML in the name. "Gord Dibben" wrote: XML not included in default menu. ToolsCustomizeCommandsData. Scroll down to bottom and you will find some XML commands which you drag up to Data menu or place on a New Toolbar. Gord Dibben MS Excel MVP On Tue, 11 Aug 2009 12:33:02 -0700, Karin wrote: Hi, I have Excel 2003 (11.8307.8221) SP3 I am using a book to learn more advanced options. The book says I should be able to point to the Data menu and choose XML in order to import XML files. I went to the Excel help, which told me the same thing. However, my Data menu has no XML option. Is there something I have to load? Thank you. Karin |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 - Import XML
I should have added in my original reply that only MS Office 2003
Professional edition supports XML. Do you have something else like Student edition? Gord On Tue, 11 Aug 2009 13:01:02 -0700, Karin wrote: Thank you - however, there is nothing in the list of commands under Data with XML in the name. "Gord Dibben" wrote: XML not included in default menu. ToolsCustomizeCommandsData. Scroll down to bottom and you will find some XML commands which you drag up to Data menu or place on a New Toolbar. Gord Dibben MS Excel MVP On Tue, 11 Aug 2009 12:33:02 -0700, Karin wrote: Hi, I have Excel 2003 (11.8307.8221) SP3 I am using a book to learn more advanced options. The book says I should be able to point to the Data menu and choose XML in order to import XML files. I went to the Excel help, which told me the same thing. However, my Data menu has no XML option. Is there something I have to load? Thank you. Karin |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 - Import XML
Help/About says "Standard Edition" - perhaps that is the problem. Bummer,
I'm trying to get an Expert certification and need to learn importing XML files. "Gord Dibben" wrote: I should have added in my original reply that only MS Office 2003 Professional edition supports XML. Do you have something else like Student edition? Gord On Tue, 11 Aug 2009 13:01:02 -0700, Karin wrote: Thank you - however, there is nothing in the list of commands under Data with XML in the name. "Gord Dibben" wrote: XML not included in default menu. ToolsCustomizeCommandsData. Scroll down to bottom and you will find some XML commands which you drag up to Data menu or place on a New Toolbar. Gord Dibben MS Excel MVP On Tue, 11 Aug 2009 12:33:02 -0700, Karin wrote: Hi, I have Excel 2003 (11.8307.8221) SP3 I am using a book to learn more advanced options. The book says I should be able to point to the Data menu and choose XML in order to import XML files. I went to the Excel help, which told me the same thing. However, my Data menu has no XML option. Is there something I have to load? Thank you. Karin |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 - Import XML
Karin,
a supplier started sending me XML files and I couldn't read them as I use XL2000. However, with OpenOffice also installed on my PC, I could use that to open the XML files and then save them as XLS. Hope this helps. Pete On Aug 11, 9:29*pm, Karin wrote: Help/About says "Standard Edition" - perhaps that is the problem. *Bummer, I'm trying to get an Expert certification and need to learn importing XML files. * "Gord Dibben" wrote: I should have added in my original reply that only MS Office 2003 Professional edition supports XML. Do you have something else like Student edition? Gord On Tue, 11 Aug 2009 13:01:02 -0700, Karin wrote: Thank you - however, there is nothing in the list of commands under Data with XML in the name. * "Gord Dibben" wrote: XML not included in default menu. ToolsCustomizeCommandsData. Scroll down to bottom and you will find some XML commands which you drag up to Data menu or place on a New Toolbar. Gord Dibben *MS Excel MVP On Tue, 11 Aug 2009 12:33:02 -0700, Karin wrote: Hi, *I have Excel 2003 (11.8307.8221) SP3 I am using a book to learn more advanced options. *The book says I should be able to point to the Data menu and choose XML in order to import XML files. * I went to the Excel help, which told me the same thing. *However, my Data menu has no XML option. *Is there something I have to load? Thank you. Karin- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I import a PDF into Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 Data Import from SQL | Excel Worksheet Functions | |||
Import Personal.XLS from 2003 to 2007? | Excel Discussion (Misc queries) | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
How can I create an XML map (2003) to import to workbook | Excel Worksheet Functions |