If it's anything like ASP, you have to do the following. 1.Declare named ranges in the .xls file 2.Make connection to the xl file 3.run query against the named range. The named range represents the table.
There's a little more to it, but that's essentially how it works. I'd also suggest checking out http://www.cfcomet.com/ for more info. If you know ASP I can send some sample code. Eric ----- Original Message ----- From: Schreck, Tom Does anyone have any helpful hints/examples of reading an excel file using CF? I'm wanting to take data from an Excel file and upload to a database table. Thanks - Tom Schreck ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
