Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pitt1
  • Order by date
  1. pitt1

    Export table to spreadsheet

    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
  2. pitt1

    Export table to spreadsheet

    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...
  3. pitt1

    sharepoint list updating problem

    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...
  4. pitt1

    sharepoint list updating problem

    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...
  5. pitt1

    sharepoint list updating problem

    can you please explain how can I link a list into excel file ? Best Pitt
  6. pitt1

    sharepoint list updating problem

    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
  7. pitt1

    how to convert a table into a text ???

    can you please be more specific..after creating the .xls file, what is the tsql procedure i should run ?? regards, pitter
  8. pitt1

    how to convert a table into a text ???

    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...
  9. pitt1

    how to convert a table into a text ???

    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...
  10. pitt1

    sql server registration problem (HELP!!!!)

    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...
  11. pitt1

    sql server registration problem (HELP!!!!)

    Hi, I use microsoft windows XP professional, version 2002, service pack 2. i tried to install microsoft sql server 2000 enterprise edition. Tahnks, Hanan
  12. pitt1

    sql server registration problem (HELP!!!!)

    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...
  13. pitt1

    sql server registration problem (HELP!!!!)

    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...

Part and Inventory Search

Back
Top