Aim : To design a COM component to perform DDL operation on SQL Server, Oracle or any other database supported by ADO.<BR><BR>Description :<BR><BR>The customer database comes in different formats like Access, Excel, text files ,etc. Whatever the data source may be it would be a single flat file or a single table with the de normalised data.<BR>The requirement is to capture the meta data of this customer database and create a new database in SQL Server or any other RDBMS with a new table having the same structure as the customer database. This whole process has to be dynamic.<BR><BR>After the creation of the database and the table ,the records which are there in the customer database has to be imported in the newly created database.<BR>