from excel file or txt file into mysql database

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

Post Reply
User avatar
ddragas
Forum Contributor
Posts: 445
Joined: Sun Apr 18, 2004 4:01 pm

from excel file or txt file into mysql database

Post by ddragas »

Hi all

How to insert data from excel file or txt file into mysql database?
User avatar
MarK (CZ)
Forum Contributor
Posts: 239
Joined: Tue Apr 13, 2004 12:51 am
Location: Prague (CZ) / Vienna (A)
Contact:

Post by MarK (CZ) »

Convert to CSV and upload e.g. via phpMyAdmin.
User avatar
ddragas
Forum Contributor
Posts: 445
Joined: Sun Apr 18, 2004 4:01 pm

Post by ddragas »

THNX
valen53
Forum Contributor
Posts: 137
Joined: Tue Aug 27, 2002 9:29 am

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
litebearer
Forum Contributor
Posts: 194
Joined: Sat Mar 27, 2004 5:54 am

Post by litebearer »

You might take a look at this

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

Lite...
Post Reply