Import .xlsx file into SQL table RRS feed

  • Question

  • Hi All,

        i have a xlsx file(excel 2016), i want to export all the data into SQL table

    but, if i use the Database->task-> import option, it gives an error (The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.)

    i tried with OPENROWSET option, even that gives the same error.

    please help me how can i load all the details in excel 2016 to SQL

    Thanks in advance

    Sunday, April 19, 2020 7:58 AM

All replies