2003 - Import XML

K

Karin

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
 
G

Gord Dibben

XML not included in default menu.

Tools>Customize>Commands>Data.

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
 
K

Karin

Thank you - however, there is nothing in the list of commands under Data with
XML in the name.
 
G

Gord Dibben

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
 
K

Karin

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

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on XML in Excel 2003 1
import XML data...Is there a size limit on the import? 0
xml import....Size limit?? Can the XML file be split?? 0
Import Multiple XML Files into Excel 3
Export XML 3
XML Import Parsing error 1
Open XML Spreadsheets with Excel 2000 1
XML Schema 0

Top