Excel in Sharepoint getting data from SQL server

[srkk]

Hi,

I am newbie to Sharepoint.

My boss intended to do this:

create a excel file which pull data from MS SQL DB (Stock Master table), then allow end user to key in more comment in Excel (add new column).

He want to have this excel publish in Sharepoint so that everyone can add in comment anytime.

He also want a Crystal Report getting data from this Excel file (after publish in Sharepoint) so that he can have bird eye view on what going on to stock.

So, in short, excel file getting data from MS SQL DB (stock master table), publish this excel in Sharepoint (so everyone can edit it), the have a crystal report to get data from this excel file.

Can this be done?
Where can I find the excel file after I publish it in Sharepoint?

edm

 

[philhege]

Excel is a bad choice for a data source and/or UI. You should add a comments table to SQL, write a Web part to query the DB and join the comments with the stock table, and allow editing of the comments field in the Web part. Publish the Web part to a shared site on your Sharepoint installation. The stored procedure that you use to populate the Web part can also be used as a data source for the Crystal Report.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[srkk]

Hi philhege,

I don't quite understand this phrase: "write a Web part to query the DB and join the comments with the stock table, and allow editing of the comments field in the Web part"

can you show me some example or any web page with tutorial that i can refer to?

edm

 

[philhege]

MSDN has a number of examples and tutorials. Start with

http://search.msdn.microsoft.com/search/default.aspx?siteId=0&tab=0&query=create+sharepoint+web+part

Good luck!

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.