John W. Colby
jwcolby at colbyconsulting.com
Tue Nov 23 08:08:11 CST 2004
Yup. PITA for sure. 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 Susan Harkins Sent: Tuesday, November 23, 2004 8:52 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] #Num! It's my experience, that most Excel error values need to be cured before importing them into Access. Susan H. 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). -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com