Thanks! I'll try and import using ODBC. Is there any good web sites
about ODBC and its operations that I can learn about it?
On Mon, 07 Mar 2005 09:26:56 +1100, Daniel Kasak
> Scott Hamm wrote:
> >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?
> Can't do that.
> You can import Access data via ODBC - that way the driver figures out
> how to send the data to MySQL.
> I assume you are trying to export to a text file and then import from that?
> The easiest way of doing this is to export your data in the correct format:
> select date_format(MyDateField, 'yyyy-mm-dd') as FormattedDateField
> I have attached a VB function that does some fancy reformatting of
> DateTime fields. You shouldn't need it in this case ( see above ), but
> it could be handy for later. I use it this way:
> - Alter the table and change your date or datetime field to a
> varchar(50) field.
> - Import into the table
> - run the attached reformat_dates() function on the table / field, which
> will format the data the correct way, and change it back to a date or
> datetime field
> Hope it helps :)