[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