I'm having problems querying Excel using ADO (with javascript). The problems arent with the connection string, it is with date/time cells.

When I query a range containing date/time cells, I always get values like "Fri Apr 21 00:00:00 EDT 2006" instead of the original value of the cell "21/4/2006". Also, all text fields within that query will display as null...
When I query a range that doesn't contain any date/time fields, all the text fields display properly.

Any help would be appreciated...

-nautica