ACTEBS
actebs at actebs.com.au
Tue Nov 23 07:41:26 CST 2004
John, I'm pretty sure I've encountered this previously. Try using something like: If IsError(YourFieldName) then whatever else whatever End if HTH Vlad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Hewson Sent: Wednesday, 24 November 2004 12:36 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] #Num! Couldn't you export 0 (zero) instead of null? Would Nz() work? Then delete all 0's in the Excel spreadsheet? Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John W. Colby Sent: Tuesday, November 23, 2004 6:10 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] #Num! I'm trying to import it into a temp table and get a "numeric overflow" when trying to do the append. This even though I have converted ALL of the fields to text. The issue is coming from a date field with null in the first record (but dates in most of the rest). John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Tuesday, November 23, 2004 6:05 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] #Num! Hi John I don't think you can. An option might be to import the worksheet to a temp table. Then you can manipulate the data as you wish. If you find a method please let us know. /gustav >>> JColby at dispec.com 22-11-2004 19:23:39 >>> Does anyone know how to convert #Num! in a linked spreadsheet to a null or something useable in Access? -- _______________________________________________ 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com