• You could just use Import Export wizard from SSMS(SQL Server Management Studio) to dump data from Excel file to SQL Server table. I would stay away from creating Linked servers for this task. Refer to this article...This might help.
    https://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/