Another way to do this is read the file, loop thru the lines and massage the
data as wanted when inserting into the database. This way you can have better
control on the data manipulation.
<cfloop file="#expandPath('.')#\sampledata.csv" from="1" index="line">
<cfquery name="qi" datasource="#mydsn#">
INSERT INTO tableONE
(
col1
,col2
,col3
,col4
)
VALUES
(
'#ListGetAt(line,1)#'
,'#ListGetAt(line,2)#'
,'#ListGetAt(line,3)#'
,'#ListGetAt(line,4)#'
)
</cfquery>
</cfloop>
Thanks,
Ketan Jetty
http://KetanJetty.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338447
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
