Write and read txt file and insert into database with coldfusion

Write and read txt file and insert into database with coldfusion, mysql and SQL Server
<cfoutput>
    <cfset HTTPUploadPath = "C:\ColdFusion10\cfusion\wwwroot\pintu\uploads\">
    <cfset inpFileName = "test.txt">


    <!---******** Start: text File Write Session ***************--->
   
    <cfparam name="fileExists" default="Yes">
    <!--- Get unique file name --->
    <cfset FileCounter = 0>
    <cfloop condition='fileExists eq "yes"'>
        <cfif FileExists("#HTTPUploadPath##inpFileName#") is "Yes">
            <cfset FileCounter = FileCounter + 1>
            <cfset fileExists="yes">
            <cfset inpFileName = "test#FileCounter#.txt">
        <cfelse>
            <cfset fileExists="no">
        </cfif>
    </cfloop>

    <cffile action="Write"
             file="#HTTPUploadPath##inpFileName#"
             output=""
            addNewLine = "NO">


    <cfquery name="getContacts" datasource="testDB">
        SELECT name_VCH,ContactNo FROM `test`.`contacts`
    </cfquery>

    <cfloop query="getContacts"    >                               
        <cfset OutputBuffer = "#name_VCH#,#ContactNo#" & CHR(13) & CHR(10)>
        <cffile action="Append"
                    file="#HTTPUploadPath##inpFileName#"
                    output="#OutputBuffer#"
                    addNewLine = "NO">
    </cfloop>                       

    <!---*********** End: text File Write Session ****************--->
      

    If you want to read .txt file and insert into table then this may be helpfull for you.


    <!---Using MYSQL--->
   
    <!---Note : If Wampserver Installed then an error occers
         File 'c:/wamp/bin/mysql/mysql5.5.24/data/ColdFusion10cfusionwwwrootpintuuploads est.txt' not found (Errcode: 22)
       
         May be helpfull - http://stackoverflow.com/questions/12657081/how-to-change-mysql-database-directory-on-wamp
         --->
            
    <cfquery name="insert" datasource="testDB">       
        LOAD DATA INFILE '#HTTPUploadPath##inpFileName#'
        INTO TABLE `test`.`contacts`
        FIELDS
            TERMINATED BY ','
            ENCLOSED BY '"'
         LINES
             TERMINATED BY '\r\n';
    </cfquery>

 <!---Using SQL SERVER--->
    <cfquery name="insert" datasource="TestDB">                       
        BULK INSERT `test`.`contacts`
        FROM '#HTTPUploadPath##inpFileName#'
        WITH
        (
            DATAFILETYPE = 'char',
            FIELDTERMINATOR = ',',
            ROWTERMINATOR = '0x0a',                       
            FIRSTROW = 1
        )
    </cfquery>
</cfoutput>