If you are on Windows then you can directly import
data using SQLyog's ODBC Import Tool.
www.webyog.com
Regards,
Karam
--- "S.D.Price" <[EMAIL PROTECTED]> wrote:
> Hi,
> can anyone explain how I would export a database
> created in Access to
> MySQL using PHPMyAdmin - I can't seem to import the
I've just seen the MySQL Migration Toolkit and looks very nice. Beautiful tool.
On 5/17/05, S.D.Price <[EMAIL PROTECTED]> wrote:
> Hi,
> can anyone explain how I would export a database created in Access to
> MySQL using PHPMyAdmin - I can't seem to import the data as csv or txt.
>
> Thanks
> St
, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
> -Original Message-
> From: EP [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 18, 2005 2:02 AM
> To: Josh Trutwin; mysql@lists.mysql.com
> Subject: Re: Export from Access
>
> I recently exported a lar
age
> From: Josh Trutwin <[EMAIL PROTECTED]>
> To: mysql@lists.mysql.com
> Date: Tue, May-17-2005 10:19 AM
> Subject: Re: Export from Access
>
> On Tue, 17 May 2005 17:17:31 +0100
> "S.D.Price" <[EMAIL PROTECTED]> wrote:
>
> > Hi,
> >
You can try a freeware utility you can find at:
http://www.bullzip.com//products.php (I have tried it and works quite well)
Additionally you could use DBDesigner (www.fabforce.com) and make a reverse
engineer of you database and export it to a Sql file.
Hope this help you.
Best regards,
Alvaro
On Tue, 17 May 2005 17:17:31 +0100
"S.D.Price" <[EMAIL PROTECTED]> wrote:
> Hi,
> can anyone explain how I would export a database created in Access
> to MySQL using PHPMyAdmin - I can't seem to import the data as csv
> or txt.
Acess should allow exporting to CSV. Otherwise you can skip
phpMyAdm
Use myodbc
www.mysql.com/downloads/api-myodbc.html
Best regards
On Fri, 10 Oct 2003 12:34:48 -0400, Montagna, Dan wrote
> Hi everyone,
>
> I'm using an Access database and trying to use a macro to export to
> a text file for mysql. It's no problem to export to a text file,
> but it's in a
