ETL tool for Excel?

Question

SQL

A wholesale company sells goods to retail stores.
Retail stores send monthly sales reports to the wholesale company in Excel format.
The formats (names and arrangement of columns and columns) are different for everyone.
It is necessary to automatically load all these files into the SQL database.
Is there any ETL tool for Excel with which one could easily set up data loading rules for each format?

Answer 1

>monthly send sales reports to the wholesale company
It turns out that they obey it, otherwise why on earth would they report ... Development of a universally mandatory report form is not an option?

Answer 2

I can suggest XLS -> convert to CSV -> import to SQL.

Answer 3

missed

Answer 4

>Formats (names and arrangement of columns and columns) are different for everyone.
I'm afraid it will be difficult to do ... Without a single format, how to understand which column belongs to which data?
But I would start with Apache POI (for Excel parsing) or jExcelApi+ Talend Open Studio. If there is a lot of money, then IBM DataStage 9.1, there seems to be a stage for Excel.
In addition, there is a solution to use the ODBC driver for EXCEL. In this case, you can use any ETL tool that has either a JDBC/ODBC Bridge or native ODBC support.

Answer 5

there are specialized
Data Defractor tools - in my opinion the most accessible and understandable
Astera Report-miner - perhaps more functional but also more complex
within their products, they made their own toolkit resistant to inserting new columns, rows, and other characters