gocush wrote:
I'm querying an Access db with ADO. One db field -DOB- has data of
Date/Time
datatype, but when I import it, it displays as General in xl.

How are you writing the recordset data to the worksheet? When I use the
CopyFromRecordset method it seems to pick up the correct format,
including my local (UK) date format.

Jamie.

--