Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SharePoint Products and Technologies >> SharePoint - Excel Services

How to persist data from excel sheet into SQL Server using Excel Services?

Hi,

I have a Excel spreadsheet and we have a requirement to write the data from that sheet into a SQL server database. How this can be done using excel services.

Any pointers to this will be really helpful.

Thanks in Advance.

-Lokeya

[247 byte] By [lokia] at [2008-3-1]
«« XML string to double or float problem
»» Combinations
# 1
Hi Lokeya
You can use Excel Services with UDF. The link below might be useful.
http://blogs.msdn.com/luisbeonservices/archive/2006/11/08/using-udfs-to-write-to-sql-databases.aspx

Thanks
Guruprasad Karnik

gpk2005 at 2007-9-12 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Excel Services...
# 2

Hi,

Can you post feed back on your experiences with this database writing. I just started doing this and would love to know what to look out for.

manasig at 2007-9-12 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Excel Services...
# 3

I see Excel Services as a publishing mechanism, not data entry mechanim.

If you want people to fill forms (excel sheets) on a regular basis and collect all that data, explore the Excel plugin for Performance Point. Here you can do some business modeling as well.

Pratyush at 2007-9-12 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Excel Services...
SharePoint Products and Technologies
SharePoint - Excel Services

SharePoint Products and Technologies Hot Topic

SharePoint Products and Technologies New Topic

SharePoint Products and Technologies

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified