PDA

View Full Version : Import CSV file data and export it in sql file



TanujKumar
02-06-2012, 03:54 AM
Hello Guys,
I'm posting thread because I did not found creating New Thread option in this forum. Actually I have a problem related to Import and Export data, I want to import CSV file data in excel file and export it in sql file so whether any option in excel or any tool through which we could perform this action. Please reply as soon as possible.

Thanks in advance!

GoluSingh
02-07-2012, 03:10 AM
Hi TanujKumar,
Yes! There is an option in Excel with the help of which you could perform this task. To perform this open Microsoft Excel and go to Data option in toolbar, here you will see to import data from external source file such as csv, xml, web file etc. But in case if you have not comfortable with excel and want to use any third party tool, you could use MindStick DataConverter, AutoConverter and many more third party tool is available in market. I had used MindStick DataConverter, it is free charge tool so you can easily download it. I don't remember the exact download path of this tool so you may use google to search it.

I hope it might be useful for you.