Importing mysql database

[arishy]

From what I read so far, I need to install mysql into my windows system !!
Then establish a connection..!!!

All what I need is to import the file.

There must be an easy way to do that without the hassle of "learning" mysql !!!

Your help will be greatly appreciated..

 

[NARAYANK991]

Hi ,

You do not have to install MySQL ; there is an add-in , as well as third-party software that does what you want , though the MySQL for Excel add-in is more than 200 MB in size !

Check these links :

1. https://blogs.oracle.com/MySqlOnWindows/entry/how_to_guide_to_importing

2. http://excel-mysql-import-export-convert-softwa.software.informer.com/7.0/

Narayan

 

[arishy]

Thank you for your response.
Is it Oracle that made it a rocket science task by design( 200 mb !!!).
I will go for the Convert software and cross my fingers....
As I said before I only want to read it and not writing back.

 

[SirJB7]

Hi, arishy!

Have you tried with this?
https://dev.mysql.com/downloads/windows/

I used to have this Add-In and it worked fine:
https://dev.mysql.com/downloads/windows/excel/

Regards!

 

[arishy]

I downloaded the convert software. Went to options (Excel 2013) and selected the addon.
Then nothing is happening... I am supposed to get Icon for MySql to click ??
I know you have not used these for sometime, so may be you direct me to a link for support ...I need a helping hand....

 

[SirJB7]

Hi, arishy!
Which converter are you talking about? If that of the link posted by NARAYANK991, I don't know it. The links I posted are related to an Excel Add-in, not a converter.
Regards!

 

[arishy]

Excel MySQL Import, Export & Convert Software 7.0

yes, using the word convert is confusing!!!