SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Blesson John / SQL Server 2008,Windows 2008 x64 and Excel / Latest Posts

RE: SQL Server 2008,Windows 2008 x64 and Excel

hrvoje.piasevoli — Tue, 28 Sep 2010 11:16:28 GMT

Hi all!Found this thread while searching for posts that describe problems of using SQL 2008 x64 and Excel.Here is an article I've written that talks problems and provides solutions for making SSIS work with the 64-bit Excel (ACE) provider.[url]http://hrvoje.piasevoli.com/2010/09/01/importing-data-from-64-bit-excel-in-ssis/[/url]Kind regards,Hrvoje Piasevoli

RE: SQL Server 2008,Windows 2008 x64 and Excel

SQLRNNR — Wed, 28 Jul 2010 19:22:10 GMT

Thanks. I have some projects coming up that I may be able to use this.

RE: SQL Server 2008,Windows 2008 x64 and Excel

Elliott Whitlow — Wed, 28 Jul 2010 14:58:42 GMT

Keep in mind when these articles were written and whether they still apply in light of the ACE 14 components. But definitely read them.CEWII

RE: SQL Server 2008,Windows 2008 x64 and Excel

Todd McDermid — Wed, 28 Jul 2010 12:37:13 GMT

For those of you looking for more resources on this subject, I have two articles related that cover some of the same ground:[url=http://toddmcdermid.blogspot.com/2009/10/quick-reference-ssis-in-32-and-64-bits.html]SSIS in 32- and 64-bits[/url][url=http://toddmcdermid.blogspot.com/2010/01/quick-reference-interacting-with-office.html]Interacting with Office in SSIS[/url]My #1 caution for those using Excel or other Office documents is to use the providers, and not the COM API, due to the [url=http://support.microsoft.com/default.aspx/kb/257757]Considerations for server-side Automation of Office[/url].For the ultimate discussion of problems, solutions, and workarounds for Excel issues in SSIS, you need to review [url=http://dougbert.com/blogs/tags/Excel/default.aspx]Douglas Laudenschlager's series of posts[/url].

RE: SQL Server 2008,Windows 2008 x64 and Excel

ryan.davidson — Wed, 28 Jul 2010 12:12:10 GMT

I would guess that doing the "Save As" to 2010 would put the file somewhere the users can't see or touch. It would be a snapshot in time that you can load into SQL, and as a added benefit you won't have SQL locking the excel file on the users.

RE: SQL Server 2008,Windows 2008 x64 and Excel

blessonblessons — Wed, 28 Jul 2010 11:52:53 GMT

Excellent news.I have a question,when I save the excel file using the saveas function,will it save the excel as a 2010 version rather than a 2003 version?If that is the case then many of our clients would require 2010 office installed on their PCs.It would be great to hear from someone who has implemented the 2010 redist on production server.By the way Varun are you covered by microsoft support on a Beta release?Nice one Elliott and Varun.

RE: SQL Server 2008,Windows 2008 x64 and Excel

Elliott Whitlow — Wed, 28 Jul 2010 11:19:06 GMT

Please review the link I sent, I don't believe it is beta anymore, I could not find a single reference either on the download page or in the install that referenced Beta.The referenced blog post was from december, the redist files I pointed at are from May of this year..And coincidently, the blog was updated to point at the redist package..CEWII

RE: SQL Server 2008,Windows 2008 x64 and Excel

Varun-Sharma — Wed, 28 Jul 2010 10:54:49 GMT

helloYes It is Beta for now , but it works just fine ... We are using it since around last three monthsI have used it for reading data into Dot Net SQLDataReader as well as with SSIS.

RE: SQL Server 2008,Windows 2008 x64 and Excel

ryan.davidson — Wed, 28 Jul 2010 10:11:00 GMT

Do you know if that distributable works with Access DBs that are 2002 / 2003?Thanks,Ryan

RE: SQL Server 2008,Windows 2008 x64 and Excel

Elliott Whitlow — Wed, 28 Jul 2010 09:16:09 GMT

Here is the MS download link for the ACE 14 files:[url]http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en[/url]I don't believe it is beta, I believe this is the release redist version.And I would start a new thread for the access discussion.CEWII

RE: SQL Server 2008,Windows 2008 x64 and Excel

ryan.davidson — Wed, 28 Jul 2010 08:43:49 GMT

Thanks for this. Was having issues with running x64 SQL Server and getting the data from the x86 Office apss into it. So, this would solve the issue I'm having with Excel, but any idea what to do with MS Access? Getting this error:[font="Courier New"]OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.[/font]May not be the right thread for this, but if someone could point me in the right direction that would be great.Thanks,Ryan

RE: SQL Server 2008,Windows 2008 x64 and Excel

Tom Garth — Wed, 28 Jul 2010 07:28:44 GMT

Nice work!Thanks for taking the time to share.

RE: SQL Server 2008,Windows 2008 x64 and Excel

blessonblessons — Wed, 28 Jul 2010 04:52:56 GMT

Thank you all for reading the article.Thanks Varun for the information but isnt it a beta version of the the driver?That should help resolve the first two problems.Does anyone know whether the Desktop folder is being created as part of the install?

RE: SQL Server 2008,Windows 2008 x64 and Excel

Varun-Sharma — Wed, 28 Jul 2010 04:26:20 GMT

new ACE Driver for 64 Bit can be used directly for handling the execl files in SSISDownload this driver and install it (available in both 64 Bit and 32 Bit)http://blogs.msdn.com/b/sqlblog/archive/2009/12/29/how-to-connect-to-file-based-data-sources-microsoft-access-microsoft-excel-and-text-files-from-a-64-bit-application.aspxOnly change that will be required in the SSIS is to change the connection string.

RE: SQL Server 2008,Windows 2008 x64 and Excel

Florian Reischl — Wed, 28 Jul 2010 02:54:01 GMT

Great article! Had the same problem some month ago. Wish I would have had this article at this time.GreetsFlo

SQL Server 2008,Windows 2008 x64 and Excel

blessonblessons — Tue, 27 Jul 2010 22:35:23 GMT

Comments posted to this topic are about the item [B]SQL Server 2008,Windows 2008 x64 and Excel[/B]