[Rdap] Archiving data in a Microsoft access database

[Abigail Goben]

You should be able to export the structure- see the first answer here:
http://stackoverflow.com/questions/28870753/how-to-export-table-structures-and-data-from-ms-access-as-txt-file

Good luck!
Abigail

On Wed, Sep 7, 2016 at 3:01 PM, Magle,Tobin <Tobin.Magle at colostate.edu>
wrote:

> Hi all,
>
> I was speaking with a researcher today about putting a large dataset into
> our repository. Part of the data is stored in a Microsoft access database.
> I know that we can export individual tables and store them as .csv/.tsv
> files for preservation, but the researcher is concerned about losing the
> linkages from the tables to raw data files (in this case interview audio)
> that are stored in Access.
>
> Has anyone encountered similar situations? If so, is there a
> straightforward way to preserve these links? I was thinking of hand linking
> them somehow through metadata, but I wanted to get some external advice
> first.
>
> Thanks,
>
> -          Tobin
>
>
>
> C. Tobin Magle, PhD
>
> Data Management Specialist
>
> Morgan Library
>
> 1019 Campus Delivery
>
> Fort Collins, CO 80523-1019
>
> (970) 491-0517
>
> tobin.magle at colostate.edu
>
>
>
>
>
>
> _______________________________________________
> Rdap mailing list
> Rdap at mail.asis.org
> http://mail.asis.org/mailman/listinfo/rdap
>
>


-- 
Abigail Goben, MLS
abigailgoben at gmail.com
http://HedgehogLibrarian.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kunverj.com/pipermail/rdap/attachments/20160907/c5155537/attachment.html>