[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