MySQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community Forums > Databases > MySQL Development
Reload this Page

excel to mysql

Discuss excel to mysql in the MySQL Development forum on Dev Articles.
excel to mysql MySQL Development forum to discuss administration, SQL syntax, and other MySQL-related topics. Find help with installing, configuring, and maintaining your MySQL databases.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old August 9th, 2002, 11:11 AM
rathaur rathaur is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Apr 2002
Location: Malaysia
Posts: 81 rathaur User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 17 m 31 sec
Reputation Power: 7
Thumbs up excel to mysql
Guys

Any idea/tutorial/scripts on how i can load data from excel file to mysql tables.Help is appreciated

Thanks
__________________
Rathaur
======================
Knowledge is Power
Reply With Quote
  #2  
Old August 10th, 2002, 12:42 AM
mytch mytch is offline
Dev Articles Novice (500 - 999 posts)
  
Join Date: Apr 2002
Location: Sydney, Australia
Posts: 589 mytch User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
Hi Rathaur,
Just export your excel data into a CSV file and use PHPMyAdmin (available from sourceforge.org) to import that file directly into your database. It saves you the hassle of having to create the queries yourself.
Reply With Quote
  #3  
Old March 12th, 2004, 05:49 PM
JimmyDubs JimmyDubs is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Mar 2004
Posts: 1 JimmyDubs User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
I use URL.
Reply With Quote
  #4  
Old March 12th, 2004, 06:34 PM
Spongy's Avatar
Spongy Spongy is offline
Alternately High
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Feb 2004
Location: Hilversum, Netherlands
Posts: 223 Spongy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 13 h 56 m 41 sec
Reputation Power: 5
Send a message via MSN to Spongy
Bluh.... it costs money...
Why purchase something excel can do itself?
I agree with Mytch here... Just export your excel sheets as CSV and import them with PHPMyAdmin...
Much cheaper solution then posted above.

Useless product from my point of view. No offence of course...

Good luck,
__________________
Work to live, don't live to work
Reply With Quote
Reply

Viewing: Dev Articles Community Forums > Databases > MySQL Development > excel to mysql

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway.