How to data input fast to mySQL?

Question

i have a website, and i need to input some massive amount of data to mySQL.

now i am using the method through phpMyAdmin, from insert command.

it is slow and i feel uncomfortable.

is there any other method for easier data input to mySQL.

maybe from microsoft access? i dont know how.

thank you

Answer 1

You can get the ODBC connector for MySQL from here:

http://dev.mysql.com/downloads/connector...

Install that, and in Access select the option to import data (this will differ depending on the version but it's normally File...Get external data or something like that). You want to choose ODBC data source from the list of available database types and when you get the "Select Data Source" popup choose the "Machine Data Source" tab.  Press "New..." and choose the MySQL driver from the list of ODBC drivers. When you finish the process the MySQL ODBC connector should pop up and you can fill in the connection details for your database. Once you've done this you'll be able to import/link all of the tables into Access.

Hope that makes sense!