I need to load my MySQl tables with data from Excel

Will the before mentioned solution work in both directions, I only need to send data from Excel to MySQl.

Is this a simple CSV or a more complicated excel file? Straightforward CSV input into mysql isn’t too tough, and can be accomplished with something like:

LOAD DATA LOCAL INFILE '/importfile.csv' INTO TABLE test_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, filed2, field3);

But if your excel file is too complicated to be exported to simple CSV first, I’m not quite sure yet…


Colby’s MySQL script is a way of creating/writing to a MySQL database from a spreadsheet/CSV file. Based on his other post, I think he wants to use Excel as a DB frontend. It is capable of reading from, but not writing to the database in a linked manner. I described how you can use MS Access as an SQL database frontend with linked tables in response to your other post.

inductiveautomation.com/foru … php?p=3079