In C# I want to execute a query that use 2 different databases (One is Access for local, and other is distant and is MySQL)

I'm able to do it in VBA Access, but how I can make the same thing in C# ??

This is how I made it in Access:

Link my 2 differents table/databases in Table

In VBA:

sSQL = "INSERT INTO DB1tblClient SELECT * FROM DB2tblClient"  
CurrentDb.Execute sSQL  

How I can execute this SQL in C# ? (What object to use, etc... Example code if you can)

Thanks !

Edit
Report