Re: How to Import a Dbase Database table into a MySQL Database..?? - Petr Vileta - com.mysql.lists.win32

3 messages in com.mysql.lists.win32Re: How to Import a Dbase Database ta...

From	Sent On	Attachments
mlist_2001	16 Sep 2003 18:37
Petr Vileta	16 Sep 2003 19:18
Mike Nelson	16 Sep 2003 20:06

Subject:	Re: How to Import a Dbase Database table into a MySQL Database..??
From:	Petr Vileta (pe...@practisoft.cz)
Date:	09/16/2003 07:18:21 PM
List:	com.mysql.lists.win32

Can anyone tell me as to how I can import a Dbase database table into MySQL database. The original database is in Access. As I did not want to continue with access, I could export the table to a Excel sheet. Using Openoffice Calc I opened this "xls" file and exported it into a DBF file.

Now as I have started using the MySQL Database server, I want this table to be exported into it. I am new to Database Technology. MySQL is the first database tool I am ever using. So I do not want to fail. The table contains almost 500 records. I am not able to do this. Can anyone suggest me how to get this big table into MySQL either from Access 2000 or from Dbase .

From Openoffice you must exprot data to CSV text file, not to DBF. In MySQL client you use LOAD DATA INFILE 'file_name.csv' INTO TABLE tbl_name TERMINATED BY ';' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' Consult MySQL manual.