[AccessD] #Num!

Hi John

That's not nice. Who makes such spreadsheets?

How about saving (via code) the worksheet to a text file (.csv) and
then read this line by line validating the fields? Not very fancy, I
know, but what options are left?

/gustav

>>> jwcolby at colbyconsulting.com 23-11-2004 13:10:09 >>>
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?