transfer spreadsheet as dbo and not user id.

  • Thread starter Thread starter mcnews
  • Start date Start date
M

mcnews

how can i use transfer spreadsheet to import data from a spreadsheet
and have the owner of the new object be dbo and not use the user's
network id as the owner?

tia,
mcnewsxp
 
then I would fiddle with giving them more permissions...

i've never had this problem.

of course; i usually use DTS to import Excel spreadsheets though; but
90% of the time someone asks me to import Excel i tell them to bugger
off and give it to me in CSV lol

-Aaron
 
the implication is that if you were using CSV files then you could just
BCP.exe and it would be hella easy and powerful

-Aaron
 
the implication is that if you were using CSV files then you could just
BCP.exe and it would be hella easy and powerful

-Aaron
 
Back
Top