This may be possible and I may just be missing it, but it would be nice if we could paste rows into a table from XL. I have a few DBs where I get data via XL and I just move the data around to match and then import it using Import External Data, but when it's just a few dozen rows it seems like it'd be nice to have a function to just paste them directly into SQLyog and update my DB that way.
This was mentioned to me by someone who was using Access to do the same thing, and I thought it actually is one nice way Access lets you speed up pasting in a handful of records.
Thanks for any ideas,
Andrew