[AccessD] Access to Excel - #Num!

Hi John

http://support.microsoft.com/default.aspx?scid=kb;en-us;162539

Had the same problem.  This fixed it.

Kind regards
Hadyn

----- Original Message -----
From: "John W. Colby" <jcolby at ColbyConsulting.com>
To: <accessd at databaseadvisors.com>
Sent: Thursday, March 20, 2003 9:50 AM
Subject: RE: [AccessD] Access to Excel - #Num!


> 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
>