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.