Page 1 of 1

from excel file or txt file into mysql database

Posted: Sun Sep 12, 2004 6:14 am
by ddragas
Hi all

How to insert data from excel file or txt file into mysql database?

Posted: Sun Sep 12, 2004 9:27 am
by MarK (CZ)
Convert to CSV and upload e.g. via phpMyAdmin.

Posted: Sun Sep 12, 2004 10:35 am
by ddragas
THNX

Posted: Sun Sep 12, 2004 8:00 pm
by valen53
beside "Convert to CSV and upload e.g. via phpMyAdmin.", any other ways insert data from excel file or txt file into mysql database?

i mean we coding it at our website use php.
if have any tutorial, please refer to me. thank u

Posted: Sun Sep 12, 2004 8:17 pm
by feyd
Without buying a tool, or knowing the binary formatting of Excel files, you are stuck as far as direct conversion is concerned.

You can use MySQL's import tool and the load data commands. Both will work with CSV files.. it's a lot easier to just use phpMyAdmin's import though.

Posted: Sun Sep 12, 2004 8:18 pm
by litebearer
You might take a look at this

http://sourceforge.net/projects/phpexcelreader/

Lite...