> 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/
---------------------------------------------------------------------------