OK CSV is some type of file format. I can export this file however I need to get the job done. I exported two ways: 1 - as a tab delimeted text file and 2 - as a CSV. They appear to be similar. Neither one of them seem to display line breaks on the web but they do break on rows when I view the files in a text editing program. Seem like I should be able to listtoarray() these if I could figure out the end-of-line and format the data first.
While it would be nice to not have to export and make this a more general use tool, the important thing at the moment is to get the data in the db without typing it all again. All thoughts on this are welcome. >If you read an CSV file.. you can see directly the output >If you don't , you need to use one of the CFX_ tags to read excel >Using Java or COM Objects. > >David Manriquez >[EMAIL PROTECTED] >(+56-2) 43 00 155 > > > >-----Mensaje original----- >De: Daniel Kessler [mailto:[EMAIL PROTECTED] >Enviado el: Martes, 28 de Junio de 2005 14:55 >Para: CF-Talk >Asunto: cffile: read in excel file > >I'm trying to read in an excel file and it does so, but the output is >crap. Well the data is in there, but there's alot of extraneous data >which shows up as unrecognizable characters. I thought that excel >was tab delimited with char returns at the end of each line. Maybe >I'm wrong for assuming this. >Is there a way to read this in where it just shows up in that way? >Should I export it differently first? Here's the code that I'm using. > ><cftry> > <cffile > action="read" > file="#form.db_file#" > variable="file_contents"> > <cfcatch type="Any"> > #cfcatch.message# > </cfcatch> ></cftry> > >file_contents:<br>#file_contents# > >thanks! > >-- >Daniel Kessler > >Department of Public and Community Health >University of Maryland >Suite 2387 Valley Drive >College Park, MD 20742-2611 >301-405-2545 Phone >www.phi.umd.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210864 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
