alter table in Excel linked server-help!!!

alter table in Excel linked server-help!!!

Post by IP » Mon, 24 Jun 2002 21:35:28

I have an Excel linked server with some tables in it.
I have an SQLServer 7.0
I can insert new entries into the Excel tables, select and update.
Is it possible to define a new column in the Excel table by an sql command
"Alter table <table> ADD newcolumn int"
I tried the syntax of
"alter table excelserver...table Add newcolumn int"
but it didn't work

1. ALTER TABLE on Linked Server

We wish to disable a trigger on a linked server.  The ALTER TABLE statement
raises the error, "...contains more than the maximum number of prefixes. The
maximum is 2."  Is there another method short of calling a remote SP on the
linked server?

2. Questions about SQL Any/D3 C/S communication

3. Alter Table & Linked Servers

4. Log Shipping

5. Help with Alter Table Alter Column

6. Unable to get the specified rows

7. Urgent help! link table from MS Excel

8. log files about database deletion?

9. link to server and link to excel.........*****

10. Need for help about Excel linked server

11. Link Server And Excel 5.0 - Please HELP !

12. Excel linkedserver - alter table problem

13. Alter table in Excel linkedserver...need4help