Good points. If there's a lot of data involved, you probably want to cut CF out of the picture entirely.
Bet there's /tons/ of MS stuphs for like, dropping them in a folder and having them auto-magically imported into MSSQL and whatnot. Yeah, the stuff I was working with is best for writing excel files (cuz it lets you do stuff POI/etc. doesn't). I had been using it for a round-trip deal-- download, modify, upload... worked pretty slick, too (since I couldn't break them of their spreadsheet habits at that time-- now they've seen the light, thankfully :]). Some stuff, spreadsheets are good for. Other stuphs... not so much. :-) :D -- I don't believe it. Prove it to me and I still won't believe it. Douglas Adams On Wed, Apr 30, 2008 at 6:11 PM, Mike Chabot <[EMAIL PROTECTED]> wrote: > The solution might depend on what you are trying to use the file for. > Are you trying to query the file via ODBC using ColdFusion? Maybe use > SSIS or a similar technology to import the data into a database and > query the database. Maybe run a 32-bit virtual machine or a second > server that handles whatever goal you are trying to accomplish. Maybe > there is some third party driver that is available. > > -Mike Chabot > > > > On Tue, Apr 29, 2008 at 4: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? > > > > Thanks, > > > > Bruce > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:304549 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

