Need help

[deep_this]

Hi All,

I have a need where, I have to read an excel file into a sql server table. Can you suggest any approches to do this. Thanks in advance.

[tclaremont]

What version of ColdFusion? Can you use CFSPREADSHEET, or import the file as a delimited file?

[deep_this]

Using COldfusion 9. I need to read data from excel file and insert into a SQL table.

[Owainnorth]

In which case, you want CFSPREADSHEET and CFQUERY. Job done.

[JMF3]

I would recommend an SSIS package on SQL Server, unless you really need to

do it in ColdFusion.

[Dan_Bracuk]

You could always use both.