> Date: Tue, 25 Mar 2003 17:23:45 -0500 > From: Mike Starke > To: PLUG > 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/ ---------------------------------------------------------------------------