MySQL - 5.1.21 beta

I'm a bit flumoxed by this interface. I cannot find a way to upload or import data to an online database. I have used YourSql, CocoaMySql, demoed Aqua Data Studio, bought SQL Boss Developer, and I cannot find a reliable program to do this necessary feature. YourSql has the nicest or easiest interface, but it fails often on uploads and introduces errors. It cannot upload all types of files {xls, csv & txt}, Cocoa is very limited in what it will upload, and I also find it failing often. Both have said number of columns do not match to the table when they clearly do. Yet there isn't enough flexibility to overcome the problem of auto indexed primary key fields... That appears to be where they choke. SQL Boss has been a better program in that regard, but crashes continuously and i don't think it is supported any more. AquaData Studio's interface is obtuse and fails to maintain connections between windows and table data... I tried dbSuite, but their site is down and it will not let me demo the Manager Pro version, because I tried the non pro version first. Other programs I see recommended here seem to be for managing data locally only....

I could write insert commands long hand, but I don't want to waste time and I barely need a program to help if I could do that well.
I checked the manual, but can't find a way to upload files from this program. Maybe I'm missing it. But I'll take some good recommendations for shareware to moderately priced programs that work and do it all.

Thanks
Jeff