excel - Database Schema Generator -

i have excel file describe table structure of database table

i generate database schema diagram , database schema structure sqlite3 database excel file.

any idea how ?

thanks.

assuming each tab named table , has cells such:

name    datatype id    integer name    varchar(255) 

use either python or java read workbook using python-excel or apache poi excel, respectively. i'm sure other languages, particularly .net have libraries purpose well. both languages have drivers sqlite3.

iterate through each tab - use tab name table create statement. iterate through each row on tab , use information define columns table. defining things primary/foreign keys , auto incrementing require additional cells or naming convention + clever algorithms.

most each create statement need passed separately on database connection.