[AccessD] Automating excel

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