<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6249.1">
<TITLE>RE: [AccessD] Access to Excel - #Num!</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><B><FONT SIZE=2 FACE="Arial">John,</FONT></B>
<BR><B><FONT SIZE=4 FACE="Times New Roman">#Num!</FONT></B>
<BR><FONT FACE="Times New Roman">The</FONT><B> <FONT FACE="Times New Roman">#Num!</FONT></B><FONT FACE="Times New Roman"> error value means that the value in the field is too large (either positively or negatively) to be stored in the field, based on the field's</FONT><B> <FONT FACE="Times New Roman">DataType</FONT></B><FONT FACE="Times New Roman"> or</FONT><B> <FONT FACE="Times New Roman">FieldSize</FONT></B><FONT FACE="Times New Roman"> property setting</FONT></P>
<BR>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Ed Tesiny</FONT>
<BR><A HREF="mailto:EdTesiny@oasas.state.ny.us"><U></U><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">EdTesiny@oasas.state.ny.us</FONT></U></A>
</P>
<UL>
<P><FONT FACE="Arial"></FONT> <FONT SIZE=1 FACE="Tahoma">-----Original Message-----</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">From: </FONT></B> <FONT SIZE=1 FACE="Tahoma">John W. Colby [</FONT><A HREF="mailto:jcolby@ColbyConsulting.com"><U><FONT COLOR="#0000FF" SIZE=1 FACE="Tahoma">mailto:jcolby@ColbyConsulting.com</FONT></U></A><FONT SIZE=1 FACE="Tahoma">] </FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">Sent: </FONT></B> <FONT SIZE=1 FACE="Tahoma">Wednesday, March 19, 2003 3:35 PM</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">To: </FONT></B> <FONT SIZE=1 FACE="Tahoma">accessd@databaseadvisors.com</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">Subject: </FONT></B> <FONT SIZE=1 FACE="Tahoma">RE: [AccessD] Access to Excel - #Num!</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I tried formatting the column as a number, no help</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">John W. Colby</FONT>
<BR><FONT SIZE=2 FACE="Arial">Colby Consulting</FONT>
<BR><A HREF="file://www.ColbyConsulting.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">www.ColbyConsulting.com</FONT></U></A>
</P>
<P><FONT SIZE=2 FACE="Arial">-----Original Message-----</FONT>
<BR><FONT SIZE=2 FACE="Arial">From: accessd-admin@databaseadvisors.com</FONT>
<BR><FONT SIZE=2 FACE="Arial">[</FONT><A HREF="mailto:accessd-admin@databaseadvisors.com]On"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">mailto:accessd-admin@databaseadvisors.com]On</FONT></U></A><FONT SIZE=2 FACE="Arial"> Behalf Of Mcgillivray,</FONT>
<BR><FONT SIZE=2 FACE="Arial">Donald [LTD]</FONT>
<BR><FONT SIZE=2 FACE="Arial">Sent: Wednesday, March 19, 2003 2:43 PM</FONT>
<BR><FONT SIZE=2 FACE="Arial">To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2 FACE="Arial">Subject: RE: [AccessD] Access to Excel - #Num!</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">John,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I've run into that when the "number" in Excel is actually a "text" value.</FONT>
<BR><FONT SIZE=2 FACE="Arial">Try converting the offending Excel value to a number using Excel's "Value"</FONT>
<BR><FONT SIZE=2 FACE="Arial">function. In my case that always took care of the problem.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">HTH</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Don McGillivray</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">-----Original Message-----</FONT>
<BR><FONT SIZE=2 FACE="Arial">From: John W. Colby [</FONT><A HREF="mailto:jcolby@colbyconsulting.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">mailto:jcolby@colbyconsulting.com</FONT></U></A><FONT SIZE=2 FACE="Arial">]</FONT>
<BR><FONT SIZE=2 FACE="Arial">Sent: Wednesday, March 19, 2003 11:20 AM</FONT>
<BR><FONT SIZE=2 FACE="Arial">To: AccessD</FONT>
<BR><FONT SIZE=2 FACE="Arial">Subject: [AccessD] Access to Excel - #Num!</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">does anyone know what #Num! is in a Excel cell? The data if clicked in the</FONT>
<BR><FONT SIZE=2 FACE="Arial">spreadsheet is a number, but when viewed in a linked table is #Num!</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">John W. Colby</FONT>
<BR><FONT SIZE=2 FACE="Arial">Colby Consulting</FONT>
<BR><A HREF="file://www.ColbyConsulting.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">www.ColbyConsulting.com</FONT></U></A>
</P>
<P><FONT SIZE=2 FACE="Arial">----------------------------------------------------</FONT>
<BR><FONT SIZE=2 FACE="Arial">Is email taking over your day? Manage your time with eMailBoss.</FONT>
<BR><FONT SIZE=2 FACE="Arial">Try it free! </FONT><A HREF="http://www.eMailBoss.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.eMailBoss.com</FONT></U></A>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">_______________________________________________</FONT>
<BR><FONT SIZE=2 FACE="Arial">AccessD mailing list</FONT>
<BR><FONT SIZE=2 FACE="Arial">AccessD@databaseadvisors.com</FONT>
<BR><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://databaseadvisors.com/mailman/listinfo/accessd</FONT></U></A>
<BR><FONT SIZE=2 FACE="Arial">Website: </FONT><A HREF="http://www.databaseadvisors.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.databaseadvisors.com</FONT></U></A>
<BR><FONT SIZE=2 FACE="Arial">_______________________________________________</FONT>
<BR><FONT SIZE=2 FACE="Arial">AccessD mailing list</FONT>
<BR><FONT SIZE=2 FACE="Arial">AccessD@databaseadvisors.com</FONT>
<BR><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://databaseadvisors.com/mailman/listinfo/accessd</FONT></U></A>
<BR><FONT SIZE=2 FACE="Arial">Website: </FONT><A HREF="http://www.databaseadvisors.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.databaseadvisors.com</FONT></U></A>
</P>
<BR>
<BR>
<P><FONT SIZE=2 FACE="Arial">----------------------------------------------------</FONT>
<BR><FONT SIZE=2 FACE="Arial">Is email taking over your day? Manage your time with eMailBoss. </FONT>
<BR><FONT SIZE=2 FACE="Arial">Try it free! </FONT><A HREF="http://www.eMailBoss.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.eMailBoss.com</FONT></U></A>
</P>
</UL>
</BODY>
</HTML>