I am not sure about Access but I use ODBC from Excel and VB.
I leave my backend in default date mode (US private format) but rely on the
ODBC driver to switch itself to ISO format (as I recall, this approach was
decided by consensus a few months back).
In VB, this seems to be converted to whatever I select in the Control Panel
Sometimes I also use the VB Format function to manipulate the raw input format.
Stephen Davies Consulting scldad(at)sdc(dot)com(dot)au
Adelaide, South Australia. Voice: 61-8-82728863
Computing & Network solutions. Fax: 61-8-82741015
pgsql-interfaces by date
|Next:||From: Bruce Momjian||Date: 1998-08-06 03:53:58|
|Subject: Large objects names|
|Previous:||From: Matthew Hagerty||Date: 1998-08-06 01:29:26|
|Subject: Re: [INTERFACES] postgresODBC and Symantec dbAnywhere/Visual