Actually I prefer to dump the dbase file on a Linux machine and directly import it into
MySQL.
----- Original Message -----
From: "Peter Brawley" <peter.brawley@stripped>
To: "Ehrwin Mina" <ehrwin@stripped>
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
> >> bg.mahesh@stripped
> >> 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
bg.mahesh@stripped
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
