Excel File with more than 256 columns

Question

Excel File with more than 256 columns

sam 55243

SSCrazy

Points: 2697
More actions
August 9, 2013 at 10:23 am

#278466

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

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246893 More actions · Answer 1

You could try outputting to a CSV file and then importing that.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Karan_W Ten Centuries Points: 1326 More actions · Answer 2

Karan_W

Ten Centuries

Points: 1326

August 12, 2013 at 3:41 am

#1640491

Yes using CSV file can be a better.

shoestringdba SSCertifiable Points: 6226 More actions · Answer 3

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.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

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 😉

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Umer Akram SSC-Insane Points: 22209 More actions · Answer 5

For Some reason ... Excel and SSIS dont really like each other 🙂

Phil Parkin SSC Guru Points: 246893 More actions · Answer 6

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 😀

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Umer Akram SSC-Insane Points: 22209 More actions · Answer 7

Umer Akram

SSC-Insane

Points: 22209

August 19, 2013 at 8:36 am

#1642725

😀 ... yeah rite

John McC Hall of Fame Points: 3410 More actions · Answer 8

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. :crazy:

COZYROC One Orange Chip Points: 28499 More actions · Answer 9

Hi Sam,

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

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