tags:

views:

39

answers:

0
+1  Q: 

Can I create database schema based on a non-standard raw Excel format?

Schema has been described crudely in Excel as follows:

tablename columnname columnid type    length description
table1    table1col1 1        int     4      blah blah
table1    table1col2 2        varchar 15     dah dah dah

table2    table2col1 1        int     4      etc

table3    table3col1 1        money   10     $$$

There is a second worksheet tab for a second database described in a similar manner. How can I create databases in SQL Server 2008 from this format?

related questions

from X import a versus import X; X.a
Python, unit-testing and mocking imports
Import Text File into generic Database using SQL
C++ include and import difference
How do you import users from Community Server into DNN?
Loading .sql files from within PHP
How does one do the equivalent of "import * from module" with Python's __import__ function?
Indirect Typelib not imported well from Debug dll
Sharepoint: How to set the permission to edit WSS user profile
Change datatype when importing Excel file into Access
Best way to import a website into a Visual Sourcesafe 2005 Database
What is the scope for imported classes in python?
Attaching Informix .dat and .idx files
Dynamically importing a C++ class from a DLL
Importing/exporting history in Team System
VB.Net (or C#) 2008 Multi Threaded Import
How to determine the Schemas inside an Oracle Data Pump Export file.
Import *variable record length* CSV file using SSIS
HTML parser in Python
How can I import a raw RSS feed in C#?
What is the difference between dllexport and dllimport?
How do I export (and then import) a Subversion repo?
Import OLE Object from Access to MySQL
What's the best way to import/read data from pdf files?
CSV File Imports in .Net