sqlexcelimportexcel-tablesexcel-template

How to import (Copy/Paste) data from Excel table to SQL query/client


How to import (Copy/Paste) data from Excel table to SQL query/client?

NB!:

  1. Without using OPENROWSET
  2. Without using online converters

Solution

  • Please try this excel to sql converter (Excel template with Power Query based solution).

    Please see some details here.