SQL Server 2008,Windows 2008 x64 and Excel

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Blesson John » SQL Server 2008,Windows 2008 x64 and Excel

16 posts, Page 2 of 2

««1 2

SQL Server 2008,Windows 2008 x64 and Excel

Rate Topic

Display Mode

Topic Options

Author

Message

blessonblessons

Posted Wednesday, July 28, 2010 11:52 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, February 06, 2013 4:46 AM
Points: 55, Visits: 391

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.

Post #960253

ryan.davidson

Posted Wednesday, July 28, 2010 12:12 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, March 05, 2013 12:15 PM
Points: 14, Visits: 61

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.

Post #960273

Todd McDermid

Posted Wednesday, July 28, 2010 12:37 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, October 30, 2012 1:38 PM
Points: 60, Visits: 159

For those of you looking for more resources on this subject, I have two articles related that cover some of the same ground:

SSIS in 32- and 64-bits
Interacting with Office in SSIS

My #1 caution for those using Excel or other Office documents is to use the providers, and not the COM API, due to the Considerations for server-side Automation of Office.
For the ultimate discussion of problems, solutions, and workarounds for Excel issues in SSIS, you need to review Douglas Laudenschlager's series of posts.

Todd McDermid - SQL Server MVP, MCTS (SQL 08 BI), MCSD.Net
My Blog - Dimension Merge SCD Component for SSIS - SSIS Community Tasks and Components

Post #960299

Elliott Whitlow

Posted Wednesday, July 28, 2010 2:58 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

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

Post #960364

SQLRNNR

Posted Wednesday, July 28, 2010 7:22 PM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:46 PM
Points: 18,732, Visits: 12,329

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

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #960431

hrvoje.piasevoli

Posted Tuesday, September 28, 2010 11:16 AM

Old Hand

Group: General Forum Members
Last Login: Friday, December 07, 2012 9:27 AM
Points: 361, Visits: 507

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.

http://hrvoje.piasevoli.com/2010/09/01/importing-data-from-64-bit-excel-in-ssis/

Kind regards,

Hrvoje Piasevoli

Hrvoje Piasevoli

Post #994666

« Prev Topic | Next Topic »

16 posts, Page 2 of 2

««1 2

Permissions