Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
Citizen99
- Forum Commoner
- Posts: 32
- Joined: Wed Dec 24, 2003 6:52 am
- Location: Where noone understand me...
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:]
-
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