How to import (Copy/Paste) data from Excel table to SQL query/client?
NB!:
OPENROWSET
Please try this excel to sql converter (Excel template with Power Query based solution).
Excel
Power Query
Please see some details here.