<div dir="ltr">You should be able to export the structure- see the first answer here: <div><a href="http://stackoverflow.com/questions/28870753/how-to-export-table-structures-and-data-from-ms-access-as-txt-file">http://stackoverflow.com/questions/28870753/how-to-export-table-structures-and-data-from-ms-access-as-txt-file</a><br></div><div><br></div><div>Good luck!</div><div>Abigail </div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Sep 7, 2016 at 3:01 PM, Magle,Tobin <span dir="ltr"><<a href="mailto:Tobin.Magle@colostate.edu" target="_blank">Tobin.Magle@colostate.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:11.0pt;font-family:"Calibri Light",sans-serif;color:#1f497d">Hi all,
<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:11.0pt;font-family:"Calibri Light",sans-serif;color:#1f497d">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.<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:11.0pt;font-family:"Calibri Light",sans-serif;color:#1f497d">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.
<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:11.0pt;font-family:"Calibri Light",sans-serif;color:#1f497d">Thanks,<u></u><u></u></span></p>
<p style="margin-bottom:12.0pt">
<u></u><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><span>-<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-family:"Calibri Light",sans-serif;color:#1f497d">Tobin</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">C. Tobin Magle, PhD<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Data Management Specialist<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Morgan Library<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">1019 Campus Delivery<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Fort Collins, CO 80523-1019<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="tel:%28970%29%20491-0517" value="+19704910517" target="_blank">(970) 491-0517</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="mailto:tobin.magle@colostate.edu" target="_blank"><span style="color:#0563c1">tobin.magle@colostate.edu</span></a><u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
<br>
<u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>______________________________<wbr>_________________<br>
Rdap mailing list<br>
<a href="mailto:Rdap@mail.asis.org">Rdap@mail.asis.org</a><br>
<a href="http://mail.asis.org/mailman/listinfo/rdap" rel="noreferrer" target="_blank">http://mail.asis.org/mailman/<wbr>listinfo/rdap</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature">Abigail Goben, MLS<br><a href="mailto:abigailgoben@gmail.com" target="_blank">abigailgoben@gmail.com</a><br><a href="http://HedgehogLibrarian.com" target="_blank">http://HedgehogLibrarian.com</a> <br></div>
</div>