In Progress

Small App to Generate DDL from Excel Workbook

Hi Folks,

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!

Tobin

Skills: .NET

See more: generate ddl excel, create ddl excel, excel ddl, excel generate ddl, create ddl console application net, create excel ddl sql, excel sql ddl, excel 2007 sql ddl, excel create ddl, ddl excel sheet, sql ddl excel, generating ddl excel, ddl app, create sql server table ddl excel, generate sql ddl excel, ddl excel, generate sql table ddl excel, generate ddl excel create table, script sheets, generate ddl excel sheet, excel sheet ddl, small server, tobin, program small, name app

About the Employer:
( 1 review ) Leeds, United Kingdom

Project ID: #187459