[AccessD] Access to Excel - #Num!

Tesiny, Ed EdTesiny at oasas.state.ny.us
Wed Mar 19 14:53:01 CST 2003


John,
#Num!
The #Num! 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 DataType or FieldSize property setting


Ed Tesiny
EdTesiny at oasas.state.ny.us

>  -----Original Message-----
> From: 	John W. Colby [mailto:jcolby at ColbyConsulting.com] 
> Sent:	Wednesday, March 19, 2003 3:35 PM
> To:	accessd at databaseadvisors.com
> Subject:	RE: [AccessD] Access to Excel - #Num!
> 
> I tried formatting the column as a number, no help
> 
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
> 
> -----Original Message-----
> From: accessd-admin at databaseadvisors.com
> [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Mcgillivray,
> Donald [LTD]
> Sent: Wednesday, March 19, 2003 2:43 PM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] Access to Excel - #Num!
> 
> 
> John,
> 
> I've run into that when the "number" in Excel is actually a "text"
> value.
> Try converting the offending Excel value to a number using Excel's
> "Value"
> function.  In my case that always took care of the problem.
> 
> HTH
> 
> Don McGillivray
> 
> -----Original Message-----
> From: John W. Colby [mailto:jcolby at colbyconsulting.com]
> Sent: Wednesday, March 19, 2003 11:20 AM
> To: AccessD
> Subject: [AccessD] Access to Excel - #Num!
> 
> 
> does anyone know what #Num! is in a Excel cell?  The data if clicked
> in the
> spreadsheet is a number, but when viewed in a linked table is #Num!
> 
> 
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
> 
> ----------------------------------------------------
> Is email taking over your day?  Manage your time with eMailBoss.
> Try it free!  http://www.eMailBoss.com
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
> 
> ----------------------------------------------------
> Is email taking over your day?  Manage your time with eMailBoss.  
> Try it free!  http://www.eMailBoss.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030319/089efc6f/attachment-0001.html>


More information about the AccessD mailing list