This tool will convert an Excel Spreadsheet (.xls and .xlsx files) into SQL INSERTs to one table.
The first row of your excel sheet will be used as the column names so you cannot have any NULL values. Then the data underneath the column name is applied into that column with the generated insert statement. You can Save or Copy the data and then use Find and Replace if you need to tweak. Good for big data.
Needed this for my work so created over the weekend, happy to share with the community.
Requires .NET framework on your PC. If you're on windows you're okay.
Features
- Convert Excel to SQL INSERTs
Other Useful Business Software
Intelligent Retail Management
Quant offers a wide range of solutions for retail. Within one integrated software system, it allows you to efficiently combine the management of retail space, shelf labels and marketing materials with task management, reporting and automatic replenishment.
Rate This Project
Login To Rate This Project
User Reviews
-
I often had personal media files to convert and it was really a hectic task to convert them in less time. Then one of my colleague recommended "Total Excel Converter". It works pretty cool for me. You can download the software from Coolutils website. They also offer free trial version. First try then buy.
-
I made this app, so I know its awesomesauce.