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?
3 ответов
+ 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.
+ 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.