Is it possible to create a plugin or anything for Excel to convert sheets to databases? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Is it possible to create a plugin or anything for Excel to convert sheets to databases?

It's silly, but would there be some way to at least make the basic structure of a simple Database using a "Special" plugin/3rd party program on MS Excel?

20th Aug 2017, 12:52 AM
Henrique Blay Barboza
Henrique Blay Barboza - avatar
2 Answers
+ 1
I'm not sure if any plugin that does the task exist but you can create a database manually by following the instructions from these links http://www.wikihow.com/Create-a-Database-from-an-Excel-Spreadsheet https://dev.mysql.com/doc/mysql-for-excel/en/mysql-for-excel-export.html Hope this helps.
20th Aug 2017, 1:50 AM
Infant Raj
Infant Raj - avatar
+ 1
I don't know if there is a plugin for this or not. There is a fair chance someone has written a VBA code to do something like this. Even if you find one what are the chances it's compatible with the database structure you intend to use? If​ I had a large excel sheet with data I want in a database I was building, this what I would do: save the spreadsheet as CSV (comma separated values), then read the CSV file into the database using a specially designed function. Note using CSV is a common way to migrate data from one database to another. This may or may not work for you, you didn't say what you wanted to achieve.
20th Aug 2017, 1:56 AM
Jared Bird
Jared Bird - avatar