 |
 |
Lynn, You could also use the PHP and especially its xml extensions to accomplish this result. The access file would not necessarily need to be flat, but it would need to comply with content standards and/or be easily mappable to EAD elements. You could pull data from related tables out with a series of sql inner joins, but you would need some pretty heavy hitting programming to do all this. It is possible, but at least as complicated as using xsl. Thanks, Chris -- Christopher J. Prom Assistant University Archivist and Assistant Professor of Library Administration University of Illinois at Urbana Champaign 19 Library 1408 W. Gregory Dr. Urbana, IL 61801 phone: 217.333.0798 fax: 217.333.2868 e-mail: [log in to unmask] web: http://web.library.uiuc.edu/ahx On Tue, 15 Mar 2005, Chatham Ewing wrote: > Lynn, > > Late model Access (2003) will produce XML output, even from relational > files. But it seems to do best with flat files. > > If the data in your Access database is flattish and already formatted to > be compliant with a content standard that satisfies you, like DACS (is > it?) and the fields you have in your database easily map to EAD tags (do > they?), then it becomes a matter of transforming the database's XML > output into EAD using XSL. > > Chatham > > > -----Original Message----- > From: Encoded Archival Description List [mailto:[log in to unmask]] On Behalf > Of Lynn Lobash > Sent: Tuesday, March 15, 2005 2:54 PM > To: [log in to unmask] > Subject: Access to EAD > > I have an Access database and would like to produce an EAD encoded file. > Any help appreciated. > > Lynn Lobash >