I have column definitions in excel. I want to create a MS Access table based on the column definition in excel. I want to create the Table structure: Field Name, Field type based on the definitions in excel. I Do NOT want to import data. The excel provides the DDL. Is there an easy way or is the solution to create a create table statement based on the excel? Does some one probably have a VBA script in case this is only solvable by script?
I have attached the excel sheet with the DDL for the MS Access Table, in sheet: 'MSAccessTable DDL', I have the attribute definition. The goal is to have a MS Access table with the according attributes - column 'ComunName' in the excel and the data type, 'column' in excel