dbase5 -> mysql

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: klsmith
Date:  
Subject: dbase5 -> mysql
> Date: Tue, 25 Mar 2003 17:23:45 -0500
> From: Mike Starke <>
> To: PLUG <>
> Subject: dbase5 -> mysql
> Reply-To:
>
> 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/
---------------------------------------------------------------------------