Display access database in sharepoint 2003

Hot Topic

What is the most valuable principle in design?
User control and Master Page
Custom Field Type Properties
MOSS 2007 Stand-Alone upgrade/migration to Web Farm
schema.xml with own fields -> Displaying them in NewItem.aspx
View Sharepoint data within CRM
Install Workflow Sharepoint
Best way to set up employee directory in MOSS 2007
Using SPFolder in custom WebService
Documenting a web site

SharePoint Products

How do you prevent users from creating personal sites?
need ideas in Web application architecture
Stored procedure vs standard query
Architecting aggregation of data
Architecture for Notification based application
Regarding MCMS 2002 and MOSS 2007 Lisences
How Can We Create BI Portal?
MSMQ: Can MSMQ resolve .\ private paths to IP instead of WINs name?
UDDI Authentication Issue
multi tier to one tier with WCF and Linq?

Display access database in sharepoint 2003

Not sure if this question is approprate here since i saw other threads are all related to MOSS 2007.

We are using SPS2003 and recently a user wants to display their MS Access data on wss site. Is there any easy way to handle that Seems data view web part cannot deal with Access db.

Btw, what shall I use to open CSV file in doc lib I tried to use "Edit in Excel", but got error: The document could not be edited. The required application may not be installed properly.

Thanks a lot




Answer this question

Display access database in sharepoint 2003

  • Gee1

    The easiest way to display Access data in SPS2003 is probably to create a web service that exposes the data and using the data view web part to consume it.

    I'm not sure about the CSV file question.
  • Display access database in sharepoint 2003
Answer this question