John W. Colby
jwcolby at colbyconsulting.com
Tue Nov 23 06:10:09 CST 2004
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