[AccessD] Automating excel

If you have mixed types in one column, you gonna have trouble.
Only way to be sure is line by line validation in Excel.. Can be done
from access..

Erwin

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Thursday, September 04, 2003 4:41 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Automating excel


John,

Could you create an "Import Specification" in Access where you could
control 
what datatype was brought into each field?

Mark


>From: "Erwin Craps" <Erwin.Craps at ithelps.be>
>Reply-To: Access Developers discussion and problem
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: RE: [AccessD] Automating excel
>Date: Thu, 4 Sep 2003 07:53:40 +0200
>
>You could open the file in excel from Access and read/evaluate line by 
>line from Access. Saving to CSV will not help your datatype property.
>Erwin
>
>-----Oorspronkelijk bericht-----
>Van: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] Namens Charlotte Foust
>Verzonden: woensdag 3 september 2003 22:09
>Aan: Access Developers discussion and problem solving
>Onderwerp: RE: [AccessD] Automating excel
>
>
>I'm not even sure you can do that, John.  Excel has a nasty habit of 
>changing datatypes no matter what you want it to do.
>
>Charlotte Foust
>
>-----Original Message-----
>From: John Colby [mailto:jcolby at colbyconsulting.com]
>Sent: Wednesday, September 03, 2003 11:56 AM
>To: AccessD
>Subject: [AccessD] Automating excel
>
>
>Has anyone ever automated Excel to save a spreadsheet as TRUE comma 
>delimited text?  My issue is that a client's client sends them data.  
>It was comma delimited text.  Now it's a spreadsheet.  Spreadsheets 
>SUCK for data import since it is possible that the data will change 
>datatypes down the spreadsheet and that causes the import to fail 
>without any warning.
>
>If I can automate excel to export that same spreadsheet, I suspect that

>the result would just be text in all cases and so that "datatype 
>change" issue would disappear.
>
>Has anyone ever done this?
>
>John W. Colby
>www.colbyconsulting.com
>
>
>_______________________________________________
>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 
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com 
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Compare Cable, DSL or Satellite plans: As low as $29.95.  
https://broadband.msn.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com