Excel to MySQL

N

Navy_Ocean

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 [email protected]
 
D

Dave Peterson

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.
 
A

Andy Wiggins

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
[email protected]
 
N

Navy_Ocean

HI, thank you so much for the information , I will try to make it work. Thank you

Navy
 
Top