Excel to MySQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi This is the first time I use online help. Never done this before...wondering if I will get something.
I need to design and administrator options for boss to update products data from Excel to MySQL, it seems too hard for me. Help Please! Navy (e-mail address removed)
 
I don't use SQL, but you'll find that you get much better responses if your
questions are specific.

So if you try something and get stuck, post back.
 
I did a Google search on "Excel" and "MySQL".

Here is one idea, I found, that might be useful: Save to a CSV
(comma-delimited file) from Excel, and take a look at the "load data
infile..." command within the mysql documentation.

Also, check out excel2mysql by Stephen Hurd:
http://www.mysql.com/Downloads/Contrib/excel2mysql

HTH

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



Navy_Ocean said:
Hi This is the first time I use online help. Never done this
Click to expand...
before...wondering if I will get something.
I need to design and administrator options for boss to update products
Click to expand...
data from Excel to MySQL, it seems too hard for me. Help Please! Navy
(e-mail address removed)
 
Back
Top