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

Do you know a good (xls to) SQL Generator?

Discuss Do you know a good (xls to) SQL Generator? in the MySQL Help forum on Dev Shed.
Do you know a good (xls to) SQL Generator? MySQL Help forum discussing administration, SQL syntax, and other MySQL-related topics. MySQL is an open-source relational database management system (RDBMS).

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 Rate Thread Display Modes
 
Unread Dev Shed 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 March 16th, 2008, 09:21 PM
menthe menthe is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Oct 2007
Posts: 39 menthe User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 12 m 41 sec
Reputation Power: 1
Do you know a good (xls to) SQL Generator?
Hi
I order data in an excel sheet, export via an old fashioned sql generator I have, and then import to mysql DB

I am looking for any good (even paid) SQL generator. Know any?

I found many via hostscripts.com and download.com but none of them worked as expected, or was easy to manage for me.

I can't remember all the ones I tried, but I really tried many. I would appreciate it if you would kindly share your experience on this.
Reply With Quote
  #2  
Old March 17th, 2008, 06:35 AM
r937's Avatar
r937 r937 is offline
SQL Consultant
Dev Shed God 25th Plane (17000 - 17499 posts)
  
Join Date: Feb 2003
Location: Toronto Canada
Posts: 17,331 r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level) 
Time spent in forums: 1 Month 3 Weeks 5 Days 7 h 21 m 33 sec
Reputation Power: 891
LOAD DATA INFILE is also quite useful
Comments on this post
SKDevelopment agrees!
__________________
r937.com | rudy.ca
Reply With Quote
  #3  
Old March 17th, 2008, 06:45 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,707 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 2 Weeks 6 Days 2 h 38 m 50 sec
Reputation Power: 259
Can't you just load your spreadsheet into MsAccess and then export your data from there to MySQL through an ODBC datasource?
Reply With Quote
  #4  
Old March 17th, 2008, 01:20 PM
menthe menthe is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Oct 2007
Posts: 39 menthe User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 12 m 41 sec
Reputation Power: 1
Quote:
Originally Posted by r937
LOAD DATA INFILE is also quite useful


thank you very much. I appreciate this.
Reply With Quote
  #5  
Old March 17th, 2008, 03:26 PM
menthe menthe is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Oct 2007
Posts: 39 menthe User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 12 m 41 sec
Reputation Power: 1
Quote:
Originally Posted by pabloj
Can't you just load your spreadsheet into MsAccess and then export your data from there to MySQL through an ODBC datasource?



thank you for your kind help pabloj

I appreciate your taking the time to answer.
Reply With Quote
  #6  
Old April 6th, 2008, 12:31 PM
Aarohi Aarohi is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Mar 2007
Posts: 7 Aarohi User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 h 54 m 51 sec
Reputation Power: 0
http://www.tjitjing.com/blog/2008/02/import-excel-data-into-mysql-in-5-easy.html
Reply With Quote
  #7  
Old April 6th, 2008, 01:44 PM
menthe menthe is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Oct 2007
Posts: 39 menthe User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 12 m 41 sec
Reputation Power: 1
Quote:
Originally Posted by Aarohi
http://www.tjitjing.com/blog/2008/02/import-excel-data-into-mysql-in-5-easy.html


thank you

but my goal was to import the data in an excel file to a mysql on my linux server.

with your method, I would import the data to a local mysql DB, then mysqldump, then mysql db < dump.sql

thus your method to me sounds like reaching my left ear with my right hand.

there probably is an easy way to directly import data from an excel csv file (or a tab-separated text file) to a mysql DB
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > MySQL Help > Do you know a good (xls to) SQL Generator?

« 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 3 hosted by Hostway.