How do I Copy a Table from one Database and OS to another?

[PGen]

I need to backup a table in a remote database (MySQL) onto a local one (in Access).

Im using VB5, ADO and ODBC but cant fathom a decent solution without complex coding.

Maybe... clone one recordset into another?
Or... create a table replica?


Thanks for your help folks.
Will

 

[petermeachem]

You can attach the table to an Access database using myodbc and run a query either in Access or VB. Peter Meachem
peter@accuflight.com

 

[PGen]

Hi Peter,

So you mean link the table to the remote odbc one?

I need to create a local backup of the remote one.

thnx

 

[petermeachem]

Yes, if you link to the remote one from Access and do select * into local from remote, this will create local, locally, and copy the data from remote in.
It may be quicker to use phpadmin or something like that to dump the mysql to a text file, copy it locally and import into access. Peter Meachem
peter@accuflight.com

 

[PGen]

Thanks for your help peter, however I am trying to code a solution in VB5 rather than do it manually in the database as the project is for technical staff with no database understanding (infact very little computer skills come to think of it).

Just had a look at Access Replication and it seems you can do it in VB using DAO but it only supports Jet Workspaces so thats no good as the remote DB is MySQL accessed via ODBC DSN.