[2005] Copy Data From Access 97 tbl to MySQL tbl

[Bongo]

Greetings,

how can i copy Fields from an Access 97 table to an MySQL table

i tried different thinks like

INSERT INTO DB1.Tbl 
   (f1, f2, f3)
      SELECT f1, f2, f3 FROM DB2.Tbl

but i could not figure out how to code it properly.

I use for accessing the Access97 DB - System.Data.OleDb
and for MySQL - MySql.Data.MySqlClient

Many thx in advance