Small App to Generate DDL from Excel Workbook

In Progress Posted Oct 19, 2007 Paid on delivery

$30-100 USD

Paid on delivery

In Progress Paid on delivery

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

[login to view URL] workbook=c:[login to view URL] 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

.NET

Project ID: #187459

About the project

Remote project Active Oct 19, 2007

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Post a project like this