[AccessD] #Num!

Hi John

In case you haven't found out yet, here is:

  wkb.SaveAs FileName:="d:\temp\test.csv", FileFormat:=xlCSV,
CreateBackup:=False

/gustav

>>> jwcolby at colbyconsulting.com 23-11-2004 15:07:48 >>>
I keep forgetting about this method.  I have never automated Excel to
save a
sheet as a csv.  Does anyone have working code to do this?

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 7:42 AM
To: accessd at databaseadvisors.com 
Subject: RE: [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).