Home |
Search |
Today's Posts |
#1
|
|||
|
|||
XML
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 W |
#2
|
|||
|
|||
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 "Ryan W" wrote: 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 W |
#3
|
|||
|
|||
How do you generate the schema you need for the mapping?
-- Ellen Deak "Gary Rowe" wrote: 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 "Ryan W" wrote: 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 W |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|