|
Seeking a software freeware XML2MDB (MS Access)
#222303 - 05/19/10 02:37 PM
|
|
|
Some of you know suggest a good freeware (if any) to convert from XML (created with MAME or MESS) to Microsoft Access (keeping all the data and populating the complete tables)? Thanks!
Edited by AntoPISA (05/19/10 04:22 PM)
|
Site: https://www.progettosnaps.net/
Board: progetto-SNAPS Official Board
Twitter: @progettosnaps
|
|
|
Re: Seeking a software freeware XML2MDB (MS Access)
[Re: AntoPISA]
#222401 - 05/20/10 10:07 PM
|
|
|
Microsoft Access already has an option to allow xml data to be imported. I have never tried to import an xml file but if you do the "Get External Data" command there is an XML option.
Kevin Eshbach
|
|
|
|
Re: Seeking a software freeware XML2MDB (MS Access)
[Re: AntoPISA]
#222402 - 05/20/10 10:27 PM
|
|
|
XML is a hierarchical data format, Access is relational tables.
I don't think there's any way to directly import MAME XML into Access.
Have you considered transforming the data from XML to CSV using XSLT?
xml2info has an external XSL file that can be edited to produce whatever format you desire...
http://mame.3feetunder.com/xml2info/
Keep in mind that there's no easy way to represent items that have one-to-many relationships like screens or dipswitches in a flat file format.
Take a look at the XSL file included with xml2info for some ideas on how to get what you want.
|
GroovyMAME support forum on BYOAC
|
|