mda1125
Guest
|
 Posted:
Fri Jan 21, 2005 12:51 am Post subject:
Data Dilemma |
|
|
I have data that resides in an external database (MS SQL 2000).
I can view the data fine from within SharePoint by using a Database
Connection created in FrontPage 2003 but the data is read-only. Or, I can
create a list in SharePoint and populate and edit it manually.
Is there a hybrid where I can write to an external database using a
SharePoint list? Or, probably less desirable, is there a way to automate the
import and export of data between SharePoint and SQL Server to keep the two
in synch?
I can see that an ASP.NET form would be a possiblility, but is there
something "out of the box" that SharePoint provides for this? |
|
Mike Walsh
Guest
|
| Posted:
Fri Jan 21, 2005 6:49 am Post subject:
Re: Data Dilemma |
|
|
Out of the box there is nothing that Windows SharePoint Services provides
for this.
The idea is to present information on a web site *from* a wide number of
sources - not to provide yet another front-end for adminstering database
systems.
Mike Walsh, Helsinki, Finland
WSS FAQ at http://wss.collutions.com
Please post questions to the newsgroup only.
"mda1125" <mda1125@discussions.microsoft.com> wrote in message
news:158795A7-5024-40A5-9D1C-92B2E2809606@microsoft.com...
| Quote: | I have data that resides in an external database (MS SQL 2000).
I can view the data fine from within SharePoint by using a Database
Connection created in FrontPage 2003 but the data is read-only. Or, I can
create a list in SharePoint and populate and edit it manually.
Is there a hybrid where I can write to an external database using a
SharePoint list? Or, probably less desirable, is there a way to automate
the
import and export of data between SharePoint and SQL Server to keep the
two
in synch?
I can see that an ASP.NET form would be a possiblility, but is there
something "out of the box" that SharePoint provides for this? |
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in