CFFILE tag reference to MS Excel is invalid.
Posted on 2006-04-18
I have recently taken over support for a ColdFusion website, and have migrated the site to a new server. There are some webpages that allow the user to upload an MS Excel file using CFFILE tag, in conjunction with CFLOOP and INSERT statements. This MS Excel upload process now fails on the CFFILE tag. The error message is:
"The destination "D:\Coldfusionsites\x.x\databases" specified in the CFFILE tag is invalid."
Can someone explain what CFFILE is trying to do, and I need to do to fix this?
<cffile action="upload" filefield="fileupload" destination="D:\Coldfusionsites\x.x\databases" nameconflict="overwrite">
<cfquery name="getExcel" datasource="ExcelData">
in 'D:\Coldfusionsites\x.x\databases\cor.xls'"Excel 8.0;IMEX=1;"
<cfquery name="addrecords" datasource="#application.dsn#">
INSERT INTO tablename