Hi. I would like to get some help from anyone who knows how to perform a remote connection to a mysql database. My mysql database is located at a web hosting company. I tried using their phpMyAdmin interface to load the data file (in .csv) format, but failed. My current system doesn't have Microsoft Access, but I have installed MyODBC. How can I upload a .csv file too the remote database?

Thanks.

Regards,
Major.

Not really sure how to connecvt using MyODBC. But the query your lookig for to load up your csv file is a LOAD DATA INFILE one try
http://www.mysql.com/doc/en/LOAD_DATA.html

If that looks a mess here is an example

LOAD DATA INFILE 'file/location.csv' INTO TABLE phone_main FIELDS TERMINATED BY ','

That will load a file called location.csv into a table called phone_main and is telling it that the values are seperated by commas.

Perhaps if you look around on that website some you might find some MyODBC stuff.

Hope that helps you

try http://www.webyog.com/
As in everything you get what you pay for and it has a sync tool.
costs around $99