PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Moderator: General Moderators
ddragas
Forum Contributor
Posts: 445 Joined: Sun Apr 18, 2004 4:01 pm
Post
by ddragas » Sun Sep 12, 2004 6:14 am
Hi all
How to insert data from excel file or txt file into mysql database?
MarK (CZ)
Forum Contributor
Posts: 239 Joined: Tue Apr 13, 2004 12:51 am
Location: Prague (CZ) / Vienna (A)
Contact:
Post
by MarK (CZ) » Sun Sep 12, 2004 9:27 am
Convert to CSV and upload e.g. via phpMyAdmin.
ddragas
Forum Contributor
Posts: 445 Joined: Sun Apr 18, 2004 4:01 pm
Post
by ddragas » Sun Sep 12, 2004 10:35 am
THNX
valen53
Forum Contributor
Posts: 137 Joined: Tue Aug 27, 2002 9:29 am
Post
by valen53 » Sun Sep 12, 2004 8:00 pm
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
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Sun Sep 12, 2004 8:17 pm
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.