Connect to a MySQL Database From Excel 2007 and Import the Database into Excel - STEP BY STEP

[LovelyLady301]

This video is absolutely awesome. You are very good at what you do. Thank you! One thing that would make things a little easier, is if there was a direct link in the "Show More" area, or if we could copy/paste the URL to download the MySQL ODBC Connector.

[otherwise777]

thnx good video helped me a bunch

[mgladdens]

Great video. Is there a similar way to export the data from excel worksheet to MySQL database?

[ExcelisHell]

@mgladdens Yes there is, especially if you use phpmyadmin. You can private message me about your specific situation or just search for it online.

[techguy1187]

AMEN!!! FINALLY SOMEONE KNOWS HOW TO EXPLAIN THIS!!!! I AM SO SUBBING!

[yanyue0]

thanks for help, man, its exactly what i need XD

[jsilvajetter]

Hi, This is a beginer's question, I think, but...

What do I put in the 'Server' field ... i mean the server name of course but what exactly is that? can you give an example? I have a shared hosting account, will I be able to access my database thru there or do I need a dedicated IP address?

[ExcelisHell]

@jsilvajetter I'll private message you the answer since you don't want too much info. about your website/db put onto the net.

[spidolino]

tnx man

[ExcelisHell]

Per user comments, note that some people say My S.Q.L. and some people say My 'sequel' and that is why I say it both ways in this tutorial. Nevertheless, I hope this tutorial has been helpful.

[75whitehawk]

very helpful, thank you. I tried it with 2003. it's perfect. helped me set up mysql odbc connection for msaccess too. thanks a lot