Yeah, the Excel ODBC thing does not work. Did it on another machine and the query to import the spreadsheet timed out after 20K records. I did use SSIS but I was having issues getting SSMS to connect to the Intelligence server. Got that fixed today thanks to a Microsoft workaround. Not just trying to get the SSIS package to execute in SSMS. It works fine in BID though. Wierd.
Bruce Mike Chabot 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:304560 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
