As described previously in the [Prerequisites] (#prerequisites) section, you have to export your Excel data as text before you can use Azure Data Factory to import it. Data Factory can't read Excel ...

Other methods could include converting Excel data into SQL statements to run via an “import” webpage on your website. You can then handle and run the SQL statements using PHP on the server side.

Import data from excel files to SQL. Contribute to Willhas17/import_Excel_to_SQL development by creating an account on GitHub.

Using SQL statements in Excel enables you to connect to an external data source, parse field or table contents and import data – all without having to input the data manually.