MySQL with ASP

Hi all,

I have a question on MySQL. I am using ASP codes for my webpage. I have an MS Access database and I am making the connections to that access MDB file. Since originally access has many disadvantages on web servers, now I want to transfer all the data in the MDB file to a MySQL database which I have created on my server. I want to use MySQL from now on and totally finish with access. All the database connections in the codes will be changed. Well, will be changed to what? So;

1. Is it possible to transfer all the data from access to mysql using a loop or something in ASP? Or do you have any other advise?
2. How is it possible for me to connect to mysql, edit/add/delete/update mysql database in ASP? What are/is the difference(s) in ASP codes? Is it okay if I change only the connection type?

Thank you for your help, best regards.

Perhaps this article will help you


As for the data transfer I prefer exporting them in a text file from access and then insert them into mysql from the text file.
I don't know is this method is appropriate for large data but it serves me well (my biggest file so far was one table with 32 colums and ~1500 records).