Skip to main content
D
deep_this
Participating Frequently
April 13, 2011
Question

Need help

  • April 13, 2011
  • 1 reply
  • 692 views

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.

    This topic has been closed for replies.

    1 reply

    tclaremont
    tclaremont
    Inspiring
    April 13, 2011

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

    D
    deep_thisAuthor
    Participating Frequently
    April 13, 2011

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

    Owainnorth
    Owainnorth
    Inspiring
    April 13, 2011

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

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices