Once you create your ODBC source from the excel files, you can run queries and use the language of your choice (Python,C# ....). I am pretty sure you can also insert/update rows and columns too.
Wondering how this differs from the approach I describe (which has existed for many years).
https://stackoverflow.com/questions/15844633/using-excel-as-...
Once you create your ODBC source from the excel files, you can run queries and use the language of your choice (Python,C# ....). I am pretty sure you can also insert/update rows and columns too.
Wondering how this differs from the approach I describe (which has existed for many years).
Good work!