import to mysql using coldfusion

[Guest]

Hi is there a way of uploading a excel sheet into mysql that has the same column names has my mysql database using coldfusion?

its a simple format with

firstname, surname, phonenumber

[jfillman]

If you do a Google search on Excel to MySQL, you should find some applications that will do this for you.

[paross1]

I suppose that you could create an ODBC datasource with your Excel file, create theColdFusion DSN, then query your spreadsheet "table" like any other database, where you could then loop through the output and insert the rows into a MySQL table.

Dynamic data sources in ColdFusion MX

Phil

[webpointz]

Try Intelligent converters...I've used their products before and it's quick and clean.

http://www.convert-in.com/xls2sql.htm