Actually I prefer to dump the dbase file on a Linux machine and directly import it into MySQL.
----- Original Message ----- From: "Peter Brawley" <[EMAIL PROTECTED]> To: "Ehrwin Mina" <[EMAIL PROTECTED]> Subject: Re: How to import data from Dbase3? Date: Wed, 23 Mar 2005 02:21:48 -0600 > > Ehrin, > > If you have dBase III or later, Clipper or FoxPro, you can export > the data comma-separated, then use a free csv-to-mysql utility eg > http://sourceforge.net/projects/csv-mysql/ to get it into mysql. > > If you don't have an xbase executable, it's a little harder, but > not much provided there's no memo file. A dbase data file is an > ASCII file with a binary header. You can read the header in any > file viewer, observe the header size, and find the field names & > lengths. The data is entirely ASCII, padded to exact col lengths, > thus simple to parse with a perl or php script. > > If there's a memo file, you need an xbase executable. > > PB > > ----- > > Ehrwin Mina wrote: > > > BG Mahesh wrote: > > > >> hi > >> > >> How do I import data from Dbase3 into MySQL? > >> > >> -- B.G. Mahesh > >> [EMAIL PROTECTED] > >> http://www.indiainfo.com/ > >> > >> > >> > > BG, > > > > There are tools you can use to migrate it to mysql, i use it > > before that i get it in the forum. You can search some forum > > indicating the migration tools for DB3, Foxpro, access. > > > > thanks, > > > > > -- No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 3/21/2005 -- B.G. Mahesh [EMAIL PROTECTED] http://www.indiainfo.com/ -- ______________________________________________ IndiaInfo Mail - the free e-mail service with a difference! www.indiainfo.com Check out our value-added Premium features, such as an extra 20MB for mail storage, POP3, e-mail forwarding, and ads-free mailboxes! Powered by Outblaze -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
