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><BR>can anyone help me out in developing this logic like how to proceed etc...<BR><BR>best regards,<BR>raju