Robert L. Stewart
rl_stewart at highstream.net
Tue Nov 23 14:10:56 CST 2004
John, I think it is caused by text in a column that Access is interpreting as a number. So the fault is in the spreadsheet data, not Access. Robert At 03:25 AM 11/23/2004 -0600, you wrote: >Date: Mon, 22 Nov 2004 13:23:39 -0500 >From: "Colby, John" <JColby at dispec.com> >Subject: [AccessD] #Num! >To: "'AccessD at DatabaseAdvisors.com'" <AccessD at DatabaseAdvisors.com> >Message-ID: <05C61C52D7CAD211A7830008C7DF6F10CBF9A8 at DISABILITYINS01> >Content-Type: text/plain; charset="iso-8859-1" > >Does anyone know how to convert #Num! in a linked spreadsheet to a null or >something useable in Access? > >John W. Colby >The DIS Database Guy