>Hej Peter..
>
>The VFP view you refer to - is it a local view or a remote view? If it is a remote view, where is your data ultimately stored?
>
>I just tested this with pure VFP data. The field remains a character type.
>
>Let's break this down step by step...

Hej John,

What´s this hej stuff, are you one of the natives?
With a name like Petersen at least the ancestry seems a foregone conclusion...

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.

That´s it.