I have > 200 tables with regular datetime fields. I link these tables through ODBC to an ACCESS database where I can run standard ACCESS append queries or even copy/paste append into the linked table. ODBC handles the conversion just fine.
One caution, MySQL timestamp maps to ACCESS datetime but ACCESS datetime does not map to MySQL timestamp. We are on ODBC 3.51.nn and MySQL 4.0.20, but we have been doing this across several versions for 3 years. -----Original Message----- From: Scott Hamm [mailto:[EMAIL PROTECTED] Sent: Friday, March 04, 2005 9:08 AM To: Mysql Subject: select date_format('2004-10-03 15:06:14','%m/%d/%y %T'); How do I create a table using: date_format('2004-10-03 15:06:14','%m/%d/%y %T'); That way I can import Access Data? -- Power to people, Linux is here. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
