[AccessD] Access to Excel - #Num!

John W. Colby jcolby at ColbyConsulting.com
Wed Mar 19 15:51:00 CST 2003


That appears to be what is happening here.  Thanks for the suggestion.

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 4:36 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Access to Excel - #Num!


John,

Maybe I'm barking up the wrong tree with this, but here's a bit more detail
about my similar experience:

I've encountered this with an Excel sheet used as a linked table, where the
Excel sheet was being populated by another person each month.  Turns out
they were cutting the data from a query of some sort (not really sure how
the query was generated, but the data came from a PeopleSoft accounting
database) and pasting it into the spreadsheet.  No matter how I looked at
the resulting data, it looked like a numeric in Excel, but when viewed via
Access I'd get the #Num! thing.  I tried reformatting the Excel column as a
number, but no glory.  The only solution I found was to convert the
offending cell values to numbers in a separate column of the sheet (using
the Value function in Excel).  Then, copy the resulting values and paste
them AS VALUES (Edit/Paste Special/Values) over the offending cells.  Lotta
crap to go thru each month - so I got them to do it on the other end ;-).

Hope this helps

Don McGillivray

> -----Original Message-----
> From:	accessd-admin at databaseadvisors.com
> [mailto:accessd-admin at databaseadvisors.com] On Behalf Of John W. Colby
> Sent:	Wednesday, March 19, 2003 12: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
_______________________________________________
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 --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 3124 bytes
Desc: not available
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030319/98bccbe5/attachment-0001.bin>


More information about the AccessD mailing list