[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

[RaviIntegra]

You can easily copy fields to your sql.

First load all tyou fields from you Access table into a listbox or listview.

Now write a query to create a table using this loaded fields.

[Bongo]

@RaviIntegra
first thanks for your idea. I tried this allready but it takes to long. We talking about around 20.000 records per table and i have to do this on 3 tables.

I was reading in the in a simelar topic (http://www.vbforums.com/showpost.php...92&postcount=5) that it is faster to copy the records directly.

So what i need is the direct way.

[Bongo]

Tried a different approach.

Getting the Datas from Access to a DataTable

Getting the Strukture from the MySQL table into another DataTable

Copy Access.DataTable to MySQL.DataTable

AcceptChange on MwSQL.DataTable

But still no luck

[Bongo]

Any other idea how this is possible to solve this?