HomeProductsAdvanced ETL ProcessorNewsSay No to TypeGuessRows=0 IMEX=1 and Excel ODBC bugs

Say No to TypeGuessRows=0 IMEX=1 and Excel ODBC bugs

New version of Advanced ETL Processor is available for download

This version addresses well known problems related to working with Excel files

  • Works directly with Excel 3.0-2007
  • No ODBC, OleDB or MS Jet Required
  • Works correctly with mixed data types
  • Works correctly with cells with more 255 characters
  • No need for IMEX=1, HDR=Yes or Registry hacks (TypeGuessRows)
  • Loads data correctly all the time + no need to edit Excel file
  • Can create Excel files in Excel 3.0-2007 format
  • Can insert data starting from specific cell
  • Can clear area before adding data into Excel
  • Can add headers

Loading Data from Excel File

List of Microsoft Excel ODBC driver bugs you do not need to deal with any more

  1. PRB: Excel Values Returned as NULL Using DAO OpenRecordset
  2. Data truncated to 255 characters with Excel ODBC driver
  3. Excel ODBC Driver May Determine Wrong Data Type
  4. BUG: Excel ODBC Driver Disregards the FirstRowHasNames or Header Setting
  5. How To Use ADO with Excel Data from Visual Basic or VBA

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 tryed DTS it did not work tried SSIS it did work either, so we wrote vb macroses 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:

  • Grouping panel was added
  • Advanced filter dialogue was introduced
  • Record number in grid
 

Advanced ETL Processor

Testimonials

We had two thousands text files in same format. We were able to load them in one click using Visual Importer ETL.

Pol Barret,
Accountant

Our customers

BP

BBC

HSBC

Databases we work with

Go to top