We have an Excel workbook that contains several sheets.
The name of the sheet identifies the table name.
In each sheet, there is text that describe the columns of a table, including field name, data type, data length, primary key etc.
We want a .NET program that reads the excel sheet, and outputs a SQL Server 2007 SQL to create the tables.
You can write in VB.NET or C#, but must be .NET 2.0
This should ideally be a "Console" application with usage as follows
[url removed, login to view] workbook=c:[url removed, login to view] first_sheet=activity one_file_per_sheet=true
In addition to generating the "CREATE TABLE" statements, the script must also generate primary keys. Some sheets specigy COMPOSITE keys, so keep this in mind.
Happy bidding, and look forward to hearing from you!