Hi,

I am not sure how to do this so I am looing for some pointers please.

I have an online MySQL database (linux server with no access via myodbc or ado) and I want to read data from this and import into a local access database.

I am using vb as the client application with ado connections to the local access database.

I need a way to get data from the MySQL database and import / delete / update into my local access database. I also need to upload data into the MySQL database.

Is it possible to do this, without direct access to the MySQL server.

My thought was to do the following.
1) create php files on the server to load a page containing the data I want to download. (basically create a csv file)
2) use the vb application to navigate to the php page (passing the variables in)
3) somehow read the php csv page into an array
4) do something with the array (update insert etc...)

Has anyone else ever done this before or is there an easier way ?

Any info will be much appreciated

Thanks

Tamath Altarak