Bob Ramsey schrieb:
At 04:10 PM 3/11/2003, [EMAIL PROTECTED] wrote:
m$office (office 2000 - win xp) can not handle the "time" correct. openoffice (win-xp or redhat-phoebe3) has no problems.
I believe that's a known problem with Microsoft products. They only appear to be able to handle datetime objects, not date or time. You might also look up the #DELETED# error on the web for similar problems.
Bob
PS. Cool. This message initially bounced back to me from the mysql list server because it didn't contain one of the following words: "sql,query,queries,smallin". "Your message cannot be posted because it appears to be either spam or simply off topic to our filter."
Now it should get through.
thanks Bob ;-)
date, datetime, timestamp all are correct in msoffice time is correctly shown in msquery, but not in access,excel, ... [...] perhaps this one http://microsoft.com/data/ from http://www.mysql.com/doc/en/MyODBC_clients.html [...]
seems to work with:
win-xp and office 2000 out of the box with myodbc-win 3.51 no update needed for "ms mdac/jet-service"
insert/update --> #deleted (german #geloescht) need: primarykey(autoincrement) timestamp
'time'-field shows wrong time or is empty need: 'datetime' instead 'time' msaccess insert eg.for 10:00 --> 1899-12-30 10:00:00 shown as 10:00:00 for 2003-01-01 --> 2003-01-01- 00:00:00 shown as 2003-01-01
do not forget relinking the table!
mysql> insert into af (af_dtime_von,af_dtime_bis) values ('18991230 10:00:00','18991230 13:00:00');
works without any problems
msoffice handle the "time" correct :-)
i will give it a chance @work with windows-users :-(
-- shrek-m
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
