RE: Import Access Data...
> 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
If you haven't found this by now:
http://forums.mysql.com/list.php?65 - MySQL forum for Access conversion.
Many people use ODBC to migra
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
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
<[EMAIL PROTECTED]> wrote:
> Scott Hamm wrote:
>
> >How do I create a table using:
> >
> >date_format('2004-10-03
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 f
