rename a table

Question

Post reply

rename a table

Gour Michel

Grasshopper

Points: 10
More actions
January 3, 2007 at 1:04 am

#171429

is it possible to rename a table in a linked server?

I woyuld like to know also is it possible to rename a Excel worksheet with Tsql

Thanks for your help

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Jules Bonnot SSCertifiable Points: 5488 More actions · Answer 1

Jules Bonnot

SSCertifiable

Points: 5488

January 3, 2007 at 5:50 am

#680935

if its a sql table have a look at sp_rename if its an excel spreaqdsheet use xp_cmdshell with dos commands.

www.sql-library.com[/url]

Gour Michel Grasshopper Points: 10 More actions · Answer 2

Gour Michel

Grasshopper

Points: 10

January 3, 2007 at 7:04 am

#680954

in dos command there no switch for renaming a worksheet

John Rowan SSC Guru Points: 56440 More actions · Answer 3

"in dos command there no switch for renaming a worksheet "

A worksheet isn't any different from any other file on the file system. Use REN/RENAME.

From DOS help -

C:\> REN /?

Renames a file or files.

RENAME [drive:][path]filename1 filename2.

REN [drive:][path]filename1 filename2.

Note that you cannot specify a new drive or path for your destination file.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Gour Michel Grasshopper Points: 10 More actions · Answer 4

Gour Michel

Grasshopper

Points: 10

January 3, 2007 at 9:09 am

#680984

i think i am maybe not clear enought

the goal is to rename the worksheet that is inside the workbook

example:

i have a workbook TEST.xls that have inside 2 worksheets

1)test1

2)test2

i would like to rename test1 to test3

thank you for your help

Chris Lane-152984 Mr or Mrs. 500 Points: 576 More actions · Answer 5

Chris Lane-152984

Mr or Mrs. 500

Points: 576

January 3, 2007 at 3:09 pm

#681077

As far as I know the only way to rename a worksheet in a workbook through code is to use the Excel API. Which I don't think you can do they way you are wanting to do this.