Re: Creating ODBC socket connection to Excel

["-==cfSearching==-" <webforumsuser@xxxxxxxxxxxxxx>]

My opinions are somewhat biased. 

 Some time ago I had some data type problems when importing from excel files 
using things like odbc or opendatasource.  Some of the issues I was unable to 
overcome.  However, that may have been due in part to my lack of experience 
with it and things may also have improved since then.  Depending on which 
version you are using, you may also have different options.

 So POI would be my preference. I like the control it offers and I more 
familiar with it than other options like JExcel.  I have not used the 
POIUtility.cfc beyond some basic testing, but I have heard good things about 
it.