MAMEWorld >> Programming
View all threads Index   Flat Mode Flat  

krick
Get Fuzzy
Reged: 02/09/04
Posts: 4235
Send PM
Re: Seeking a software freeware XML2MDB (MS Access)
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







Entire thread
Subject Posted by Posted on
* Seeking a software freeware XML2MDB (MS Access) AntoPISA 05/19/10 02:37 PM
. * Re: Seeking a software freeware XML2MDB (MS Access) krick  05/20/10 10:27 PM
. * Re: Seeking a software freeware XML2MDB (MS Access) keshbach1  05/20/10 10:07 PM

Extra information Permissions
Moderator:  Pi 
0 registered and 86 anonymous users are browsing this forum.
You cannot start new topics
You cannot reply to topics
HTML is enabled
UBBCode is enabled
Thread views: 3866