Is there a free app or script that will load an Excel spreadsheet into MySQL? Everything I've seen is around $100 and my client doesn't seem to want to pay for anything.
Any help would be appreciated.
Why not just save the excel document as csv text and import into a table using LOAD DATA?
Nevermind, I found what I need in the manual. Imagine that.
How can be done that? any reference?
You can just use the mail merge function in Word 97.
Works for my data, anyway.
anything for excel?
I found something for free that loaded right from an excel file, but it has been a lot easier to just convert to a CSV file and use that.
I dump data FROM MySQL to csv all the time so it makes since you could do it the other way around. I just hadn't thought to try it yet lol.
