Retrieving excle schema

HI all,
How can I retrieve the schema of set range froman excle spreadsheet. The
range has the valid data that I need inorder to create a staging table, But
once the staging table is created I do not want to recreate it everytime
with the select into, as i am setting indexes and triggers on this staging
table. Once the staging table is created it would mostliley be used from
that point on/
Thanks
RobertAfter you've created the staging table using SELECT...INTO script it out
using your favourite editing tool, then in your script replace the
SELECT...INTO statement with a CREATE TABLE and an INSERT...SELECT statemens
.
On scripting out SQL objects' DDL:
http://www.aspfaq.com/etiquette.asp?id=5006
ML
http://milambda.blogspot.com/