Hello,
I have searched past messages to the list and have seen some recommendations
for the csvtoquery custom tag
to put the spreadsheet data into a query. What makes my situation unique (I
think) is that the spreadsheet has
commas in the data in some of the columns. I tried CSVformat and am able to
print out the data on row at a time. Where I am stuck now is how to get
this information into the DB and how to get it in the right fields as right
now it is printing all columns for each employee on one line each and it
blows up the query when I try to insert #item# as the Value. Any Help is
GREATLY appreciated!
here is my code so far:
<cffile action="READ"
file="#File.ServerDirectory#\#File.ServerFile#"
variable="excelList">
<cfset NewList = Replace(excelList, "#chr(13)#", "^", "ALL")>
<cfset NewList = Replace(excelList, "#chr(10)#", "^", "ALL")>
<cfloop index="item"
list="#NewList#"
delimiters="^">
<cfoutput>#item#</cfoutput><br>
</cfloop>
A working version, with csv and txt files available is at
http://www.high-techsolutions.net/development/UpLoad.cfm
TIA,
Dave
______________________________________________________________________
Why Share?
Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
