[AccessD] #Num!

Jim Hewson JHewson at karta.com
Tue Nov 23 07:35:31 CST 2004


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



More information about the AccessD mailing list