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
Christopher J. Prom
Assistant University Archivist and
Assistant Professor of Library Administration
University of Illinois at Urbana Champaign
1408 W. Gregory Dr.
Urbana, IL 61801
e-mail: [log in to unmask]
On Tue, 15 Mar 2005, Chatham Ewing wrote:
> 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.
> -----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