Post reply

Using a local Excel file in an SQL Server query

  • March 8, 2019 at 1:20 pm

    #382955

    we keep data in an Excel spreadsheet on a local drive.
    Can i use that data in an SQL query??
    I do not have permissions to create tables.  I thought our previous BI Expert did this.
    THoughts?  We want to use this technique a lot, and although i COULD make temp tables every time, that is not efficient.

    thanks

  • March 8, 2019 at 3:58 pm

    #2024006

    yes, you can read xls files into sql server using openrowset(), it requires specific permissions and is typically used for loading data into a table.
    If it were possible to read data directly from xls files, the performance would be categorically diabolical.
    Surely it would be more efficient to load all your excel files into tables periodically and then query the data from within SQL. What's the point of having a SQL server otherwise?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply