Skip navigation links

MySQL Forums


Advanced Search

Convert MS Access to MySQL (Date Convert Question)
Posted by: Mark Brown ()
Date: April 06, 2007 07:09AM

Hello,
I'm brand new to MySql, so please bear with me here as I muttle thru learning it.

I have a MS Access Database that I want to import to MySql. The each record in Access has 3 date field that are formatted mm/dd/yyyy. I plan to export the db from Access to a text file then load it into MySql. I'll load it per the Tutorial in the MySql documentation. Question is, is there an easy way at some point in this process to convert the dates to MySql format (yyyy/mm/dd)?

Thanks in advance for your help.
Mark



Edited 1 time(s). Last edit at 04/06/2007 09:45AM by Mark Brown.

Options: Reply•Quote


Subject Written By Posted
Convert MS Access to MySQL (Date Convert Question) Mark Brown 04/06/2007 07:09AM
Re: Convert MS Access to MySQL (Date Convert Question) kadfi lui 04/06/2007 04:12PM
Re: Convert MS Access to MySQL (Date Convert Question) Mark Brown 04/06/2007 06:53PM
Re: Convert MS Access to MySQL (Date Convert Question) Guelphdad 04/07/2007 12:47AM
Re: Convert MS Access to MySQL (Date Convert Question) Mark Brown 04/07/2007 04:37PM
Re: Convert MS Access to MySQL (Date Convert Question) Travis Bullock 04/08/2007 10:08PM
Re: Convert MS Access to MySQL (Date Convert Question) Mark Brown 04/27/2007 09:56AM
Re: Convert MS Access to MySQL (Date Convert Question) Guelphdad 04/27/2007 10:37AM
Re: Convert MS Access to MySQL (Date Convert Question) Mark Brown 04/27/2007 11:57AM
Re: Convert MS Access to MySQL (Date Convert Question) Guelphdad 04/27/2007 04:02PM
Re: Convert MS Access to MySQL (Date Convert Question) Mark Brown 04/30/2007 07:02AM


Sorry, you can't reply to this topic. It has been closed.
powered by phorum