Hi All,

I am trying to import a column from excel 8.0 using DAO with vb5. The problem I am having is that the column I am trying to import has a mixture of numerals and text.

As far as I can tell I have the excel initialization settings of 'ImportMixedTypes' set to text, and 'TypeGuessRows' set to 8 and have also tried 2 and 1.

This is what happens...

12345.001
23456.001L
34567.001

It will read 12345.001 and 23456.001L but returns null for 34567.001

Any ideas?

Cheers,
David