uploading, reading, inserting file into DB

[JulieN]

I would like to be able to upload an excel spreadsheet and insert it's data into a SQL database. <br>
<br>
Right now, I'm able to upload the file using CFFILE - Upload, and I've played around with using the CFFILE - Read, but it only reads a text file.<br>
<br>
Does anyone have any advice or suggestions?<br>
<br>

 

[Guest_imported]

The Best way to handle this is to save your Excel file as a comma or tab delimited file, then you won't have any problem parsing it in Cold Fusion.

 

[JohnB]

You can make the excel spreadsheet an ODBC and read it just like you can any table. You will have to give the spreadsheet a name(internally) and a name range, but once you do that the name becomes the table and it works very well.

 

[jsadler]

Hi,

I'm trying to do the same thing and am wondering if anyone has a sample of creating the ODBC DSN 'on-the-fly' or has a better method of just extracting the data from excel.

JulieN, I'd really appreciate seeing how you did it if you managed to? leith1@(deletespam)hotmail.com

cheers
j. [sig][/sig]