Importation from Excel yields also another kind of problem. Since the data sampling is beeing done with the first 8 rows of data sometimes unwanted results can arise. For example if there is only one column in the excel sheet containing AlphaNumerics in the first rows and some rows with a number in it, the resulting import will contain NULL for the rows with a numeric.

As far as I know there is no way of getting those values into you import. There is no way of interpreting these numerics as AlphaNumerics and store them as text.

I would be very happy if anyone has a solution to this that does not involve using Excel Automation.

/Hans