>What´s this hej stuff, are you one of the natives?

The folks were born and raised in Danmark.


>Anyway, it´s a local view, and the stuff ultimately ends up in an Excel sheet, but the whole thing seems to go haywire already at the ADO level.
>
>I did not write the VB code and I don´t know a lot about ADO, but my view contains something like this:
>
>SET DATE ANSI
>SELECT Db.This, Db.That, Db.The_Other, DTOC(Db.Date) AS Date FROM DB
>
>Somehow ADO (or whatever) seems to recognize the Date field as a DATE type.
>

Hmmmm. I guess it begs the question of why you are converting the date to a char type.

Again, I tested on a local view. The field still comes back as a char type. Why don't you post your ADO code...