Max Wanadoo
max.wanadoo at gmail.com
Mon Aug 31 17:31:28 CDT 2009
Top of head Doug, Have you tried changing them to text strings and then back again after moving. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele Sent: 31 August 2009 23:27 To: accessd at databaseadvisors.com Subject: [AccessD] SQL datetime to Access date conversion Hello All: I have a SQL 2005 table linked into an Access db. I am using an update query in Access to move some datetime fields from SQL Server to an Access table. It almost works - the dates are OK, but I am getting times which are sometimes out by a couple of minutes: for instance the time part of one field, 2:00:00 PM in SS, is changed to 1:58:07 PM in Access. Does anyone have any suggestions about why this happens? Thanks, Doug Steele -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com