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

Excel File with more than 256 columns Expand / Collapse
Author
Message
Posted Friday, August 9, 2013 10:23 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, December 15, 2014 6:21 AM
Points: 63, Visits: 576
Hi All,

I have an excel file with more than 256 columns. And the current driver (Jet OLEDb) doesnt supports that, it can read till 256 columns.

Please let me know how to load the data from the excel file to a sql table usiing SSIS 2005.

Thanks
Sam
Post #1482854
Posted Sunday, August 11, 2013 11:40 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:52 PM
Points: 5,317, Visits: 12,353
You could try outputting to a CSV file and then importing that.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

It is better to keep your mouth shut and appear stupid than to open it and remove all doubt. (Mark Twain)
Post #1483139
Posted Monday, August 12, 2013 3:41 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 4, 2014 2:11 AM
Points: 44, Visits: 135
Yes using CSV file can be a better.
Post #1483202
Posted Monday, August 12, 2013 5:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:55 AM
Points: 155, Visits: 285
CSV files can also alleviate some headaches from newer versions of Excel, which don't always play so well with SSIS 2005.

____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
Post #1483234
Posted Monday, August 12, 2013 5:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 12:52 PM
Points: 13,636, Visits: 11,509
lshanahan (8/12/2013)
CSV files can also alleviate some headaches from newer versions of Excel, which don't always play so well with SSIS 2005.


The older versions of Excel also don't play nice with Excel




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1483237
Posted Monday, August 12, 2013 6:06 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: Yesterday @ 3:33 AM
Points: 856, Visits: 1,506
For Some reason ... Excel and SSIS dont really like each other
Post #1483244
Posted Monday, August 12, 2013 6:46 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:52 PM
Points: 5,317, Visits: 12,353
twin.devil (8/12/2013)
For Some reason ... Excel and SSIS dont really like each other


It's because Excel thinks it knows what you want: so that even when you ask for something specific, it gives you what it thinks you want, not what you asked for.

This seems to suit accountants



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

It is better to keep your mouth shut and appear stupid than to open it and remove all doubt. (Mark Twain)
Post #1483270
Posted Monday, August 19, 2013 8:36 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: Yesterday @ 3:33 AM
Points: 856, Visits: 1,506
... yeah rite
Post #1485849
Posted Tuesday, August 20, 2013 8:55 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 6:57 AM
Points: 568, Visits: 1,618
Phil Parkin (8/12/2013)
twin.devil (8/12/2013)
For Some reason ... Excel and SSIS dont really like each other


It's because Excel thinks it knows what you want: so that even when you ask for something specific, it gives you what it thinks you want, not what you asked for.

This seems to suit accountants


Amen to that.


-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible.
Post #1486290
Posted Saturday, September 7, 2013 7:40 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, September 14, 2014 3:17 PM
Points: 1,118, Visits: 2,224
Hi Sam,

If you can use third-party solutions, check the commercial COZYROC SSIS+ library. It contains Excel adapters which support more than 256 columns.


---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #1492529
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse