Yes and no. I have successfully imported data from an Excel spreadsheet into TMS 9.35.<br><br>These were 200 odd objects comprising a gamelan - and none had existing records in TMS. Additionally, almost all of the pieces shared similar attributes (such as maker and context), which made their import easier.<br>
<br>To aid in the import, I created a stored procedure that handled all of the heavy lifting. I then used the mail merge function in Microsoft Word to create a list of SQL commands with the values supplied by the spreadsheet, which I executed in the SQL console. Run some DB Config functions to rebuild search indexes, update statistics, etc, etc. And Bob&#39;s your uncle...<br>
<br>It&#39;s not very pretty, but it worked.<br><br>~Chad Petrovay<br>Cultural Heritage Data Solutions | 602.400.7826<br><br><div class="gmail_quote">On Fri, Apr 1, 2011 at 7:23 AM, Diane Lee <span dir="ltr">&lt;<a href="mailto:[log in to unmask]"><a href="/cgi-bin/wa?LOGON=A3%3D1104%26L%3DTMSUSERS%26E%3Dquoted-printable%26P%3D18615%26B%3D--00151773e3409c2b97049fe059a8%26T%3Dtext%252Fhtml%3B%2520charset%3DISO-8859-1%26pending%3D" target="_parent" >[log in to unmask]</a></a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">









<div link="blue" vlink="purple" lang="EN-US">

<div>

<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">I would be interested in any replies as
well. </span></font></p>

<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">&nbsp;</span></font></p>

<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">&nbsp;</span></font></p>

<div>

<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">==========================================</span></font><font color="navy"><span style="color: navy;"></span></font></p>


<p class="MsoNormal"><b><b><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Diane Lee</span></font></b></b><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">, Collections Manager </span></font><font color="navy" face="Wingdings" size="2"><span style="font-size: 10pt; font-family: Wingdings; color: navy;"> </span></font><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> 860-236-5621 x242</span></font><font color="navy"><span style="color: navy;"></span></font></p>


<p class="MsoNormal"><b><b><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Connecticut Historical
Society</span></font></b></b></p>

</div>

<div>

<div class="MsoNormal" style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt; font-family: &quot;Times New Roman&quot;;">

<hr size="2" width="100%" align="center">

</span></font></div>

<p class="MsoNormal"><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;"> The Museum
System (TMS) Users [mailto:<a href="mailto:[log in to unmask]" target="_blank"><a href="/cgi-bin/wa?LOGON=A3%3D1104%26L%3DTMSUSERS%26E%3Dquoted-printable%26P%3D18615%26B%3D--00151773e3409c2b97049fe059a8%26T%3Dtext%252Fhtml%3B%2520charset%3DISO-8859-1%26pending%3D" target="_parent" >[log in to unmask]</a></a>] <b><span style="font-weight: bold;">On Behalf Of </span></b>Christine Droll<br>
<b><span style="font-weight: bold;">Sent:</span></b> Friday, April 01, 2011 10:15
AM<br>
<b><span style="font-weight: bold;">To:</span></b> <a href="mailto:[log in to unmask]" target="_blank"><a href="/cgi-bin/wa?LOGON=A3%3D1104%26L%3DTMSUSERS%26E%3Dquoted-printable%26P%3D18615%26B%3D--00151773e3409c2b97049fe059a8%26T%3Dtext%252Fhtml%3B%2520charset%3DISO-8859-1%26pending%3D" target="_parent" >[log in to unmask]</a></a><br>
<b><span style="font-weight: bold;">Subject:</span></b> Access to TMS?</span></font><font face="Times New Roman" size="3"><span style="font-size: 12pt; font-family: &quot;Times New Roman&quot;;"></span></font></p>

</div><div><div></div><div class="h5">

<p class="MsoNormal"><font face="Calibri" size="2"><span style="font-size: 11pt;">&nbsp;</span></font></p>

<p class="MsoNormal"><font face="Calibri" size="2"><span style="font-size: 11pt;">Good
morning, all,</span></font></p>

<p class="MsoNormal"><font face="Calibri" size="2"><span style="font-size: 11pt;">&nbsp;</span></font></p>

<p class="MsoNormal"><font face="Calibri" size="2"><span style="font-size: 11pt;">Has
anyone successfully imported data from a Microsoft Access database to TMS9.35?</span></font></p>

<p class="MsoNormal"><font face="Calibri" size="2"><span style="font-size: 11pt;">&nbsp;</span></font></p>

<p class="MsoNormal"><font face="Calibri" size="2"><span style="font-size: 11pt;">Any
thoughts, suggestions, comments, or how-to&rsquo;s would be greatly
appreciated.</span></font></p>

<p class="MsoNormal"><font face="Calibri" size="2"><span style="font-size: 11pt;">&nbsp;</span></font></p>

<p class="MsoNormal"><font face="Calibri" size="2"><span style="font-size: 11pt;">Christine</span></font></p>

<p class="MsoNormal"><font face="Calibri" size="2"><span style="font-size: 11pt;">&nbsp;</span></font></p>

<p class="MsoNormal"><font color="#365f91" face="Calibri" size="1"><span style="font-size: 9pt; color: rgb(54, 95, 145);">Christine Droll</span></font></p>

<p class="MsoNormal"><font color="#365f91" face="Calibri" size="1"><span style="font-size: 9pt; color: rgb(54, 95, 145);">Collections Database Administrator</span></font></p>

<p class="MsoNormal"><font color="#365f91" face="Calibri" size="1"><span style="font-size: 9pt; color: rgb(54, 95, 145);">The Nelson-Atkins Museum of Art</span></font></p>

<p class="MsoNormal"><font color="#365f91" face="Calibri" size="1"><span style="font-size: 9pt; color: rgb(54, 95, 145);">4525 Oak Street</span></font></p>

<p class="MsoNormal"><font color="#365f91" face="Calibri" size="1"><span style="font-size: 9pt; color: rgb(54, 95, 145);">Kansas City, MO&nbsp; 64111-1873</span></font></p>

<p class="MsoNormal"><font color="#365f91" face="Calibri" size="1"><span style="font-size: 9pt; color: rgb(54, 95, 145);">t: 816.751.1333</span></font></p>

<p class="MsoNormal"><font color="#365f91" face="Calibri" size="1"><span style="font-size: 9pt; color: rgb(54, 95, 145);">f: 816.751.0499</span></font></p>

<p class="MsoNormal"><font color="#365f91" face="Calibri" size="1"><span style="font-size: 9pt; color: rgb(54, 95, 145);"><a href="mailto:[log in to unmask]" target="_blank"><a href="/cgi-bin/wa?LOGON=A3%3D1104%26L%3DTMSUSERS%26E%3Dquoted-printable%26P%3D18615%26B%3D--00151773e3409c2b97049fe059a8%26T%3Dtext%252Fhtml%3B%2520charset%3DISO-8859-1%26pending%3D" target="_parent" >[log in to unmask]</a></a></span></font></p>


<p class="MsoNormal"><font face="Calibri" size="2"><span style="font-size: 11pt;">&nbsp;</span></font></p>

<p class="MsoNormal"><font face="Calibri" size="2"><span style="font-size: 11pt;">&nbsp;</span></font></p>

</div></div></div>

</div><div><div></div><div class="h5">


To unsubscribe, send an email to <a href="mailto:[log in to unmask]" target="_blank"><a href="/cgi-bin/wa?LOGON=A3%3D1104%26L%3DTMSUSERS%26E%3Dquoted-printable%26P%3D18615%26B%3D--00151773e3409c2b97049fe059a8%26T%3Dtext%252Fhtml%3B%2520charset%3DISO-8859-1%26pending%3D" target="_parent" >[log in to unmask]</a></a> with the following commands in the body of the email:
<p>
     signoff TMSUSERS
</p><p>
     //  eoj
</p><p>
</p></div></div><p>
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to <a href="mailto:[log in to unmask]" target="_blank"><a href="/cgi-bin/wa?LOGON=A3%3D1104%26L%3DTMSUSERS%26E%3Dquoted-printable%26P%3D18615%26B%3D--00151773e3409c2b97049fe059a8%26T%3Dtext%252Fhtml%3B%2520charset%3DISO-8859-1%26pending%3D" target="_parent" >[log in to unmask]</a></a> with the following commands in the body of the email:
</p><div class="im"><p>
     signoff TMSUSERS
</p><p>
     //  eoj
</p><p>
</p><p>
You will receive a confirmation that your subscription has been removed.</p></div></blockquote></div><br>
To unsubscribe, send an email to <a href="mailto:[log in to unmask]"><a href="/cgi-bin/wa?LOGON=A3%3D1104%26L%3DTMSUSERS%26E%3Dquoted-printable%26P%3D18615%26B%3D--00151773e3409c2b97049fe059a8%26T%3Dtext%252Fhtml%3B%2520charset%3DISO-8859-1%26pending%3D" target="_parent" >[log in to unmask]</a></a> with the following commands in the body of the email:
<p>
     signoff TMSUSERS
</p><p>
     //  eoj
</p><p>
</p><p>
You will receive a confirmation that your subscription has been removed.