dbase5 -> mysql

[klsmith]

> Date: Tue, 25 Mar 2003 17:23:45 -0500
> From: Mike Starke <meg@lilly.csoft.net>
> To: PLUG <plug-discuss@lists.plug.phoenix.az.us>
> Subject: dbase5 -> mysql
> Reply-To: plug-discuss@lists.plug.phoenix.az.us
>
> I have the import about 1200 entries into a mysql database.
> I have two type of files to import from: dbase5, or ASCI txt.
>
> I can certainly struggle along and eventually whip up a perl
> script to parse out the txt file, but was wondering if there
> were utilities for something like this already.
>


I was able to connect to MySql with FoxPro using an ODBC connection.  I
created views for every table...ETC.

I think you can just append to the view at that point.  Maybe a simple
command line :

1) select viewname
2) append from dbase5table


Keith

---------------------------------------------------------------------------
Keith Smith
(520) 358-2138
http://www.TucsonCarSales.com/
---------------------------------------------------------------------------