Hi,
I'm trying to do this automatically, just like the option
i get when i'm using a sharepoint list: "Export to spreadsheet", if its can be done programmatically, i dont really know how
Best,
Pitt
Hi all,
I'm viewing a sql table in a sharepoint Document,
i do this using some web service, (i coul'd also have done that using a data view, insert data base connection)
my problem is that either way i don't know how to convert this data into excel, while using sharepoint's lists enables me to...
gee thanks, i thought ill have to add a web service into the project (which makes things bit more complicated...)
if I understood you correctly, I’m choosing
"database connections" (under “insert data view”) and then choosing server, db, table and so on….this goes just fine,
But when I’m...
ok, sorry if i wasn't clear, i'm novice to this area...
there is a sharepoint site with a list which is being updated manually once in a week, now, i dont have access to the list db, there is a table on a sql server which the data to be updated (on the list) is being taken from, and currently...
I want to automatically update a sharepoint list on a regular basis (lets say weekly)
I dont have access to the actual list on the sql server db.
I want to update the sharepoint list from a sql server
db table
can you please tell me how can I do that ??
Best,
Pitter
thnks man ! u saved me few hours...
i have encountered couple of problems,
1. if the table is quite big, i'm getting this
message from the server :
"Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80004005"
if i'm selecting less rows it works just fine...
Hi folks,
I'm a novice in sql server, I would like to
know how to convert a table into a text, that is,
i actually want to send a table by mail, and i think i can't really send the table itself, i have to convert it into text,i'll appreciate if someone can show how to write a stored procedure...
oh boy....thanx a lot,
but the thing is i managed to install some of the sql server enterprise ed., since i have the option to choose the enterprise manager, and have the option to make a server registration in it,
that means that it will be possible to register a remote server ??? (not my...
Hi,
I use microsoft windows XP professional, version 2002,
service pack 2.
i tried to install microsoft sql server 2000 enterprise edition.
Tahnks,
Hanan
thanx for the quick rspond,
1. i'm using windows XP os.
2. installed microsoft sql server 2000 + sp3
i tried to run "services.msc" but i can't find the MSSQLSERVER, only found MSSQLServerADHelper and MSSQLServerOLAPService,
maybe it has to do with the fact that during installation I could...
Hi all !
I’ve just installed sql server 2000, and wanted to work on my pc, as a database server,
In the enterprise manager, I choose the option :
- new sql server registration (under Microsoft sql srvers)
then in the register sql server wizard, I choose my machine’s name as a server,
in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.