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

Import excel 2010 spreadsheet Expand / Collapse
Author
Message
Posted Monday, August 27, 2012 2:18 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, November 20, 2013 2:29 AM
Points: 97, Visits: 189
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:54 PM
Points: 2,866, Visits: 2,871
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




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1350285
Posted Monday, August 27, 2012 3:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:42 PM
Points: 13,203, Visits: 10,064
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


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 8:01 PM
Points: 3,605, Visits: 5,198
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.



My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
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?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.


Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1350288
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse