EXCEL -> MYSQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Citizen99
Forum Commoner
Posts: 32
Joined: Wed Dec 24, 2003 6:52 am
Location: Where noone understand me...

EXCEL -> MYSQL

Post by Citizen99 »

I need help with converting data from excel to mysql, (xls -> csv -> mysql). Maybe someone could help me ? THX.
McGruff
DevNet Master
Posts: 2893
Joined: Thu Jan 30, 2003 8:26 pm
Location: Glasgow, Scotland

Post by McGruff »

Once you've created a csv file, you can use the db manager phpMyadmin to import to mysql.

If you want to write your own script, check out LOAD DATA INFILE in the mysql manual.
Citizen99
Forum Commoner
Posts: 32
Joined: Wed Dec 24, 2003 6:52 am
Location: Where noone understand me...

Post by Citizen99 »

I cant see import, only export, where is it ? I also try to write my own script :] THX for help:]
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

in phpMyAdmin go to SQL. Set it so it phpMyAdmin knows that your are uploading CSV and then upload your CSV-file.
Citizen99
Forum Commoner
Posts: 32
Joined: Wed Dec 24, 2003 6:52 am
Location: Where noone understand me...

Post by Citizen99 »

ThX
Post Reply