XML

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a database in MS Access 2000 that I collect data and then through
queries I export the data to MS Excel 2003. I don't have any problems with
that. But is there a way that I can create mappings from MS Excel 2003 to
XML? I have learned how to import XML data into MS Excel 2003, but if the
data originates in MS Excel 2003 how can I get it out to XML? Can anyone
suggest books/websites? Or is there a tool that I can use? Thank you in
advance!
 
Ryan,
MS Access 2003 provides this functionality. You can export to XML as an
option and create a schema which then can be mapped in excel. Mappings are
created in excel by connecting the data in an xml file together with its
schema to particular cells in the spreadsheet. The book "XML in Office 2003:
Information Sharing with Desktop XML" by Charles Goldfarb and Priscilla
Walmsely is a good resource.
-Gary
 

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

2003 - Import XML 5
Ms.Office suite for XML integration 1
Export XML 3
Open XML Spreadsheets with Excel 2000 1
Question on XML in Excel 2003 1
import XML data...Is there a size limit on the import? 0
Import Multiple XML Files into Excel 3
Excel 2003, Convert EXISTING Worksheet Data to XML? 4

Back
Top