Import excel 2010 spreadsheet

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » SQL Server 2008 » SQL Server 2008 - General » Import excel 2010 spreadsheet

Add to briefcase

Import excel 2010 spreadsheet

Expand / Collapse

Author

Message

Posted Monday, August 27, 2012 2:18 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 11:13 AM
Points: 89, Visits: 160

Hi

I tried to import excel 2010 spreadsheet, but I can not find any option for 2010, higest version seems to be excel 2007.

Any comment on how to do this, or do I have to store my excel spreadsheet as 93-2007 or 2007.

BR
Dan

Post #1350248

Posted Monday, August 27, 2012 3:42 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 1:02 PM
Points: 1,878, Visits: 1,450

Hi,

In SSMS go to Server objects then to Linked servers and see your providers. May be you have to install a new one for office 2010, or to make some settings in their properties.
The following link may help you also: http://www.microsoft.com/en-us/download/details.aspx?id=13255

Regards
IgorMi

Post #1350285

Posted Monday, August 27, 2012 3:47 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:51 AM
Points: 9,373, Visits: 6,470

I guess you are using SSIS?
Take the 2007 option, normally it should work.

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 #1350286

Posted Monday, August 27, 2012 3:50 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 3:20 AM
Points: 2,341, Visits: 3,175

Koen Verbeeck (8/27/2012)

I guess you are using SSIS?
Take the 2007 option, normally it should work.

Agreed. The .xlsx format in 2010 has not changed from 2007.

No loops! No CURSORs! No RBAR! Hoo-uh!

INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Are you too recursively challenged?
Splitting strings based on patterns can be fast!

Post #1350288

« Prev Topic | Next Topic »

Add to briefcase

Permissions

Expand / Collapse