Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SQL Server 2008,Windows 2008 x64 and Excel Expand / Collapse
Author
Message
Posted Wednesday, July 28, 2010 11:52 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 16, 2014 1:00 PM
Points: 55, Visits: 416
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
Posted Wednesday, July 28, 2010 12:12 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 17, 2013 10:32 AM
Points: 14, Visits: 66
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
Posted Wednesday, July 28, 2010 12:37 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 2:51 PM
Points: 60, Visits: 161
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
Posted Wednesday, July 28, 2010 2:58 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:02 PM
Points: 6,032, Visits: 5,284
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
Posted Wednesday, July 28, 2010 7:22 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 8:18 PM
Points: 17,824, Visits: 15,756
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #960431
Posted Tuesday, September 28, 2010 11:16 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 11:33 PM
Points: 361, Visits: 510
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 »

Add to briefcase ««12

Permissions Expand / Collapse