|
Author |
Message |
laychoo135
Junior WebHelper
![Junior WebHelper Junior WebHelper](images/rank_1.gif)
Joined: 03 Jul 2003
Posts: 5
|
Posted:
Thu Jul 03, 2003 1:38 am (20 years, 11 months ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
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? |
|
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by laychoo135 Find all posts by laychoo135](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) |
![](images/spacer.gif) |
Daniel
Team Member
![](images/rank_6.gif)
![](http://www.4webhelp.net/forums/images/daniel_avatar.php)
Joined: 06 Jan 2002
Posts: 2564
|
Posted:
Thu Jul 03, 2003 7:41 am (20 years, 11 months ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
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 ). |
________________________________
![Image Image](http://www.4webhelp.net/images/daniel_sig.gif) |
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by Daniel Find all posts by Daniel](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) |
![](images/spacer.gif) |
laychoo135
Junior WebHelper
![Junior WebHelper Junior WebHelper](images/rank_1.gif)
Joined: 03 Jul 2003
Posts: 5
|
Posted:
Mon Jul 07, 2003 5:51 am (20 years, 11 months ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
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. |
|
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by laychoo135 Find all posts by laychoo135](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) |
![](images/spacer.gif) |
drathbun
WebHelper
![WebHelper WebHelper](images/rank_2.gif)
Joined: 01 Mar 2003
Posts: 69
Location: Texas
|
Posted:
Mon Jul 07, 2003 10:08 pm (20 years, 11 months ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
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 |
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by drathbun Find all posts by drathbun](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) ![Visit Poster's Website Visit Poster's Website](templates/4WebHelp2/images/lang_english/icon_www.gif) |
![](images/spacer.gif) |
jayant
Team Member
![](images/rank_6.gif)
![](http://www.phpbuilder.com/board/avatar.php?userid=132268&dateline=1069059954)
Joined: 07 Jan 2002
Posts: 262
Location: New Delhi, India
|
Posted:
Tue Jul 08, 2003 11:36 am (20 years, 11 months ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by jayant Find all posts by jayant](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) ![Visit Poster's Website Visit Poster's Website](templates/4WebHelp2/images/lang_english/icon_www.gif) ![Yahoo Messenger Yahoo Messenger](templates/4WebHelp2/images/lang_english/icon_yim.gif) ![MSN Messenger MSN Messenger](templates/4WebHelp2/images/lang_english/icon_msnm.gif) |
![](images/spacer.gif) |
|
|
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.116982 seconds :: 18 queries executed :: All Times are GMT
Powered by phpBB 2.0
© 2001, 2002 phpBB Group :: Based on an FI Theme
| |