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 Tuesday, July 27, 2010 10:35 PM
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
Comments posted to this topic are about the item SQL Server 2008,Windows 2008 x64 and Excel
Post #959822
Posted Wednesday, July 28, 2010 2:54 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 4, 2012 12:23 PM
Points: 1,893, Visits: 3,932
Great article! Had the same problem some month ago. Wish I would have had this article at this time.

Greets
Flo



The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems
Post #959897
Posted Wednesday, July 28, 2010 4:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 19, 2012 7:51 AM
Points: 2, Visits: 11
new ACE Driver for 64 Bit can be used directly for handling the execl files in SSIS

Download 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.aspx

Only change that will be required in the SSIS is to change the connection string.
Post #959930
Posted Wednesday, July 28, 2010 4: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
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?
Post #959941
Posted Wednesday, July 28, 2010 7:28 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, February 4, 2011 7:20 AM
Points: 977, Visits: 1,499
Nice work!

Thanks for taking the time to share.


Tom Garth
Vertical Solutions

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
Post #960024
Posted Wednesday, July 28, 2010 8:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 17, 2013 10:32 AM
Points: 14, Visits: 66
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:


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.


May not be the right thread for this, but if someone could point me in the right direction that would be great.

Thanks,
Ryan
Post #960086
Posted Wednesday, July 28, 2010 9:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:02 PM
Points: 6,032, Visits: 5,284
Here is the MS download link for the ACE 14 files:
http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en
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
Post #960118
Posted Wednesday, July 28, 2010 10:11 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 17, 2013 10:32 AM
Points: 14, Visits: 66
Do you know if that distributable works with Access DBs that are 2002 / 2003?

Thanks,
Ryan
Post #960178
Posted Wednesday, July 28, 2010 10:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 19, 2012 7:51 AM
Points: 2, Visits: 11
hello
Yes It is Beta for now , but it works just fine ... We are using it since around last three months
I have used it for reading data into Dot Net SQLDataReader as well as with SSIS.
Post #960215
Posted Wednesday, July 28, 2010 11:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:02 PM
Points: 6,032, Visits: 5,284
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
Post #960237
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse