If your data model lives for a week at a time, it's probably not correct.

To answer your question, import the spreadsheet into SQL, then build the CREATE TABLE statements, and run them using EXECUTE.

P



-----Original Message-----
From: Ramirez Efrain
[mailto:mssqldba-ezmlmshield-x22059632.[Email address protected]
Sent: Friday, May 27, 2005 4:31 PM
To: LazyDBA Discussion
Subject: Importing Metadata


What is the easiest way to create tables when the table fields, types, length, etc., is provided via an Excel spreadsheet? I would type them in but tables are getting larger,(50+ columns) and they change every other week. The format of the Excel Spreadsheet stays the same.

Thanks!

Efrain Ramirez



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

MS Sql Server LazyDBA home page