Home Forums SQL Server 2012 SQL 2012 - General OpenRowSet works locally but not over networked drives RE: OpenRowSet works locally but not over networked drives

  • July 10, 2013 at 2:17 pm

    #1631401

    Elliott Whitlow (7/10/2013)

    I looked at the output and immediately latched onto the first 2 characters, PK, are you sure this is an XLS file and not a ZIP file maybe containing an XLS file? I might be reading too much into it..

    I took an xls file and zipped it and the first few characters were: PK??¶, that looks pretty similar to your output..

    CEWII

    I'm positive. That seems to be the first line of output for any .xlsx file in the folder. The only one TYPE reads as human is a text file that's also in there.