On Tue, Apr 29, 2008 at 2:48 PM, Bruce Sorge <[EMAIL PROTECTED]> wrote: > So I googled the hell out of this, and unless I am missing something, > Microsoft again assumed that they know what's best for developers and > decided to exclude the MS Excel ODBC source dll (msdasql.dll) from the > 64 bit version of Windows Server 2003 (as well as a shit load of > others). So does anyone have a way for me to connect to an MS Excel > spreadsheet other than creating the System DSN, which I can't?
I've got some code that uses JExcelAPI for reading/writing Excel stuphs. You can point it at a file and get queries back for the various worksheets. I think it's easier than the POI/etc. stuff, but you do need createObject privileges. http://code.google.com/p/cfjexcel/ Probably go for the source from the repo, as I do occasionally work on it but hardly never update those zip files / build numbers. xls2query is the cfc you'd want. Hit me up if you decide to try it and have questions. Otherwise (and maybe better) do a search for "coldfusion POI excel" and see what's out there. :d -- In order to fly, all one must do is simply miss the ground. Douglas Adams ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304543 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
