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/

Retrieve SQL Server data via MS Query to spreadsheet

Hi,
Here is a security question: what way can I restrict the access to SQL
Server 2005 database objects ?
I'm going to let some my users use some tables, views to create their own
MSQuery queries to retrieve data from SQLServer, but not all ones! (I have
hundreds of tables, views, sprocs...)
What is the bast practices both from server side and Excel-side for this
kind of restriction ?
Thanks,
szabtiBest thing is to create a special login in sql server and grant the user to
have permission only to those tables.
These permission depends on what all privileges you want to grant them, if
its simple select , them give only db_datareader access
vt
"szabti" <tibor.szabo@.iconsulting.hu> wrote in message
news:uANKaC4FHHA.5004@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Here is a security question: what way can I restrict the access to SQL
> Server 2005 database objects ?
> I'm going to let some my users use some tables, views to create their own
> MSQuery queries to retrieve data from SQLServer, but not all ones! (I have
> hundreds of tables, views, sprocs...)
> What is the bast practices both from server side and Excel-side for this
> kind of restriction ?
>
> Thanks,
> szabti
>|||szabti
Security is a huge subject especially in SQL Server 2005. I'd suggest to
spend a few days to study it .BOL is good place to start.
"szabti" <tibor.szabo@.iconsulting.hu> wrote in message
news:uANKaC4FHHA.5004@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Here is a security question: what way can I restrict the access to SQL
> Server 2005 database objects ?
> I'm going to let some my users use some tables, views to create their own
> MSQuery queries to retrieve data from SQLServer, but not all ones! (I have
> hundreds of tables, views, sprocs...)
> What is the bast practices both from server side and Excel-side for this
> kind of restriction ?
>
> Thanks,
> szabti
>