How do I import data from several Excel files into MySQL database?
Posted on 2010-09-20
I have approximately 3000 excel files, invoices to be exact. I am looking to import specific cells from these invoices (name, address, telephone numbers, etc) into a MySQL database. They are the same set of cells on every invoice. What is the best way to automate the process of what would be opening each excel file, and manually entering the names, addresses, and phone numbers into the database I've created?
Thanks in advance,