Home Forums SQL Server 2005 SQL Server Express getting null values while imporing from excel RE: getting null values while imporing from excel

  • July 8, 2014 at 2:18 am

    #1727670

    visu.viswanath (7/8/2014)

    Thanks for replay, i have one more doubt ...

    Is there any limitation for file size through query not from SSIS package.

    it gives error message as

    "server is not responding to dump the excel file" for 2.5 MB file and it works for 1.5 Mb file.

    It doesn't look like an MS error message. What tool are you using to run your TSQL OPENROWSET script?

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden