|
Author |
Message |
laychoo135
Junior WebHelper
Joined: 03 Jul 2003
Posts: 5
|
Posted:
Thu Jul 03, 2003 1:38 am (20 years, 9 months ago) |
|
Hi all
Wish to know are there ways to convert Excel spreadsheet to MySQL? I have a long list of data in Excel format. It would be tedious to key in them in MySQL.
I know there are sofwares on the net that can do the conversion but they are chargeable.
What is PHPAdmin and how it is installed? Install on my pc (windows) or on the Apache server? |
|
|
|
|
Daniel
Team Member
Joined: 06 Jan 2002
Posts: 2564
|
Posted:
Thu Jul 03, 2003 7:41 am (20 years, 9 months ago) |
|
phpMyAdmin can be installed anywhere you want, but it is usually installed by your host.
Simply export your Excel spreadsheet in CSV format. Then upload this file in phpMyAdmin . Make sure you give the same column names in your table and your spreadsheet (I assume you have already created the table and columns in MySQL ). |
________________________________
|
|
|
|
laychoo135
Junior WebHelper
Joined: 03 Jul 2003
Posts: 5
|
Posted:
Mon Jul 07, 2003 5:51 am (20 years, 9 months ago) |
|
How do I upload the CSV file using phpAdmin after I have exported the excel spreadsheet to CSV format and created the tables & columns in MySQL. |
|
|
|
|
drathbun
WebHelper
Joined: 01 Mar 2003
Posts: 69
Location: Texas
|
Posted:
Mon Jul 07, 2003 10:08 pm (20 years, 9 months ago) |
|
laychoo135 wrote: | How do I upload the CSV file using phpAdmin after I have exported the excel spreadsheet to CSV format and created the tables & columns in MySQL. |
There is a "load data" option that will let you point to the file right on your workstation, upload it, and insert it into the database. Works very well, assuming you have defined everything correctly.
Dave |
________________________________ Dave
Photography Site :: Query Tools Forum :: Weekend Fun |
|
|
|
jayant
Team Member
Joined: 07 Jan 2002
Posts: 262
Location: New Delhi, India
|
Posted:
Tue Jul 08, 2003 11:36 am (20 years, 9 months ago) |
|
|
|
|
|
|
You cannot post new topics in this forum. You cannot reply to topics in this forum. You cannot edit your posts in this forum. You cannot delete your posts in this forum. You cannot vote in polls in this forum.
|
Page generation time: 0.165544 seconds :: 19 queries executed :: All Times are GMT
Powered by phpBB 2.0
© 2001, 2002 phpBB Group :: Based on an FI Theme
| |