Importing access with code..

[Dennis Bijlsma]

Hello all,

I am new to mysql and I have problems importing access db through code.. It works but IT IS SO SLOW..
How do I do it...
First I create a dataset with the values from the access database then I make a copy of this dataset to another dataset. Then I make a connection to the mysql server and also create a dataadapter. Then I update this datadater with the copied dataset. datadaptermysql.update(copydataset). Here the problems start this line takes 30 seconds for 1000 records..

I also have a program that does the import for me and he needs 2 seconds for the same database..

MY QUESTION IS:
Is there a better and faster way to import from access to mysql with code???

I hope you can help me.. Please give examples...

Dennis