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

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

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

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

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

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 -