The new version of Advanced ETL Processor is available for download
This version addresses well-known problems related to working with Excel files
| || |
The sad story is: what ever you use: Excel ODBC, MS Jet, Ole DB, .NET sooner or later you will hit the brick wall.
You can not load the data correctly without modifying excel file. We receive thousands of excel files every day.
I mean do you seriously expect us to modify them manually every day? What kind of automation is that?
We tried DTS it did not work tried SSIS it did work either, so we wrote vb macros to extract the data.
We do not do it any more since we have discovered Advanced ETL processor It saved us thousands of hours.
Also Data grids modifications:
- A grouping panel was added
- Advanced filter dialogue was introduced
- Record number in the grid