John W. Colby
jwcolby at colbyconsulting.com
Wed Nov 24 09:44:06 CST 2004
Cool, thanks! 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: Wednesday, November 24, 2004 4:45 AM To: accessd at databaseadvisors.com Subject: RE: [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). -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com