Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

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


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



Group: General Forum Members
Last Login: Today @ 2:12 PM
Points: 14,547, Visits: 38,412
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.


help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1450672
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse