Hello all,

I need to transfer ceratin tables in My Sql to Access in Visual Basic using ADO. Is there a way out for that? Could it be done without copying record by record? I mean I want to do it as a whole table. I have a recordset open in MY Sql connection and a recordset open in Access connection? Any soultions for this??