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

excel migration issue Expand / Collapse
Author
Message
Posted Wednesday, May 8, 2013 10:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 17, 2013 9:13 PM
Points: 21, Visits: 69
i dont think we have a handle. We're likely not going to be able to explain why it runs on one server and not another. BTW the link you listed originally for download is for 2010. Do you believe it will be backward compatible to our 2007 excel files?
Post #1450669
Posted Wednesday, May 8, 2013 10:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:23 AM
Points: 12,915, Visits: 32,074
yes; the link i posted used the latest drivers that are compatible with opening all previous excel formats,

I've connected to pre-2007 xls, 2007 xlsx and 2010 xlsx spreadsheets with no problem before.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1450672
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse