Home Forums SQL Server 2008 SQL Server 2008 - General Copy from Excel file into SQL table using BCP RE: Copy from Excel file into SQL table using BCP

  • March 4, 2014 at 2:15 pm

    #1694094

    I'm not sure you can read Excel with bcp (you can write to Excel with bcp though).

    You can use FROM OPENROWSET to read an excel file, or just use SSIS (with is the same as the import wizard).

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP