Main Area and Open Discussion > General Software Discussion

creating SQL from excel, soft at bitsdujour today. Worth it?

(1/1)

urlwolf:
There is an app for creating SQL from excel at bitsdujour today

http://bitsdujour.com/blog2/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:
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.

* MySQL's own GUI tools
* Toad for MySQL

Navigation

[0] Message Index