Upload Document from Access to MYSQL

[frustrating]

I'm not sure if this is the best place to ask this question, but...

Using Access as the front end, Is there a best method of importing a csv document into a MySql DB? Would the best way be doing a vba insert loop on the raw document? That seems like it would take a long time. I'm just trying to think of the best way to move a raw document into MySQL DB using the existing Access form as the thing that will start the routine.

Any ideas?

 

[Uncle Gizmo]

Comma separated value (CSV) format is basically a database in text form. You should be able to Import this CSV into a table in MS Access, which you can link to MySQL via odbc or will possibly already be linked to MySQL via odbc depending on how you've got it setup.

 

[plog]

Why must this go through Access? I would use phpMyAdmin (https://www.phpmyadmin.net/).