Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • September 05, 2015, 05:17:41 AM
  • Proudly celebrating 10 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: creating SQL from excel, soft at bitsdujour today. Worth it?  (Read 1784 times)

urlwolf

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 1,794
    • View Profile
    • Donate to Member
creating SQL from excel, soft at bitsdujour today. Worth it?
« on: January 30, 2007, 08:45:17 AM »
There is an app for creating SQL from excel at bitsdujour today

http://bitsdujour.co...og2/wordpress/?p=289

I tested it a bit. It feels a bit clunky, no keyboard shortcuts to change types etc (GUI is poor, maybe because it's just a macro?).

Is there a better alternative to create sql visually and fast from say csv?

Oh, BTW, another nice tool if you need to interact with a remote MySQL server without a shell is SQLyog.

http://www.sqlyog.com/
It has SQL syntax highlighting, command completion, you can see all the tables at once etc.

tinjaw

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 1,927
    • View Profile
    • Read more about this member.
    • Donate to Member
Re: creating SQL from excel, soft at bitsdujour today. Worth it?
« Reply #1 on: January 30, 2007, 09:18:41 AM »
I bought it, but not for myself. I have some friends that have the data I need to get into MySQL. They can use Excel but not MySQL. So I will loan them my laptop and have them create the stuff in Excel, and then I will get into MySQL.

As for visual tools, I suggest two.