-
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
Hi there's a free utility name dbf2mysql I assume you are running dbase3
plus under windows/dos
Look for it in google or ask me and I would send it to you.
I´ve used it under windows with dbf tables from Clipper, dBase and Fox
It doesn't require ODBC drivers at all.
greetings
Mauricio
On
Do you want to do a one time import ?
Create an ODBC source that maps to the dBase datasource and write an
application to read it from there and import into mysql.
- Navneet
BG Mahesh wrote:
hi
How do I import data from Dbase3 into MySQL?
--
B.G. Mahesh
[EMAIL PROTECTED]
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
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
I remember seeing some JDBC drivers for Java to read dbase 3 files. So
it might be a good idea to use that to understand the files and import
the data using the mysql jdbc drivers into the mysql database.
We can help you do it (provided you pay) since we have already done
similar exercise for
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
BG Mahesh wrote:
Actually I prefer to dump the dbase file on a Linux machine and directly
import it into MySQL.
There are a bunch of ways of skinning that cat. The easiest of which
IMHO is to convert the data to comma separated files first
If you have ms access you can import the db3 into access and then export
thru odbc to MySql
Osvaldo Sommer
-Original Message-
From: BG Mahesh [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 22, 2005 10:33 PM
To: mysql@lists.mysql.com
Subject: How to import data from Dbase3?
hi
How do
Hi,
How do I import data from Dbase3 into MySQL?
My software, libmygis, is mainly designed for loading a set of
Shapefiles into MySQL (.SHP, .SHX, .DBF) but it's perfectly well capable
of loading just the dBase III/IV component. Grab libmygis-0.5.1 from:
http://jcole.us/software/libmygis/
If Dbase3 has an odbc driver then you can use SQLyog
(www.webyog.com) to import data to MySQL.
Karam
--- Peter L. Berghold [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
BG Mahesh wrote:
Actually I prefer to dump the dbase file on a
Linux machine and directly
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,
11 matches
Mail list logo