Re: Convert Access to MySQL

From:	Julie Meloni	Date:	Thu, 24 Aug 2000 19:04:29 +0000
Subject:	Re: Convert Access to MySQL
References:	1	Groups:	php.db
Request:	Send a blank email to php-db+get-2346@lists.php.net to get a copy of this message

Joe Lloyd wrote:

I was wondering if anyone had converted an access DB to MySQL. If so could you pass along any hints/tips/howto.

1) in access, save as comma-delimited (or other delimiter) 2) in MySQL monitor or through your scripts, use LOAD DATA INFILE ... - julie +------------------------------------------------+

| Julie Meloni (jcm@i2ii.com)                    |

| Tech. Director, i2i Interactive (www.i2ii.com) |

|                                                |
|      "PHP Essentials" & "PHP Fast & Easy"      |
|            http://www.thickbook.com/           |

+------------------------------------------------+