Skip to main content
Participant
June 28, 2007
Question

Read Excel in CF

  • June 28, 2007
  • 1 reply
  • 300 views
I've done a lot of online searching and have found a lot of references, but not a good one that explains how to read an excel file in CF MX 7. I've attempted to do it myself

If anyone has any good/working solutions, with examples of code used in a CF page, I'd really appreciate it.
I need to know:
1. How to set up my excel file
2. Set up the ODBC connection
3. Set up the datasource in CF ADmin
4. Display the data in an CF page

Thanks!
    This topic has been closed for replies.

    1 reply

    June 28, 2007
    If you save it as a comma delimited file, you can loop through the data without setting up an ODBC connection.