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?
Scott
On Mon, 07 Mar 2005 09:26:56 +1100, Daniel Kasak
<dkasak@stripped> wrote:
> 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 :)
<..>
