cffile

[cfhelp]

How do you read a file into a table?

Thanks in advance.

 

[pigsie]

I'm assuming your file is in a particular format.

Using sql server you can use dts to import the data i think you can also do this in coldfusion.

TO so it using cffile you would need to loop over the contents of the file line ny line (check for the newline operator) and then save each row into the database. Your row will need to have the fields seperated and you will have to be able to determine when fields are blank.

Finally i think there are tags to do this on the developer exchange at macromedia.com

HTH

 

[Guest_imported]

Thanks pigsie,

My file contains:

SSN, Name, Address, Title, StartDate, EndDate

Here is what I have:

<cffile action = &quot;read&quot; File = &quot;#outfile#&quot; variable = &quot;txtinput&quot;>

<cfset myarray = ListToArray(txtinput)>

<cfloop from = &quot;1&quot; to= &quot;#arraylen(myarray)#&quot; index = &quot;this&quot;>
<cfoutput>#myarray[this]#</cfoutput>
</cfloop>

Now that the file is in an array, how would I loop through it and insert into the database?

Thanks