×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Displaying Access Data on Sharepoint

Displaying Access Data on Sharepoint

Displaying Access Data on Sharepoint

(OP)
Hi All,
Here is what I have:

An Access 2007 db that has a table with data that I want to display on a SharePoint dashboard as both a datasheet and a chart.

Here is what I want:

The SharePoint display (both chart and datasheet) to be updated with the most current data automatically, either when someone opens the page or on a set schedule. In other words, I don't want to have to manually upload a new file everytime I want to update the data.

Now I can link/import said data to an excel spreadsheet which I can configure to automatically update itself and then use that to generate a PivotChart or I can even just setup a query to compile the data and have it ready to export into an excel file at a file path of my choosing. But everytime I try to upload the file the Sharepoint site throws an error about using external table data and the only way I have been able to get it to work is if I dump the data into excel (with no refreshable link) and manually upload the file to the SharePoint in order to get updated data.

Is what I want to do at all possible?

I appreciate any assistance you all can provide.

Travis
www.apexsystemsinc.com
 

RE: Displaying Access Data on Sharepoint

(OP)
If I'm reading the information correctly, you suggest setting up a table in SharePoint (by means of importing the data from Access) and then linking that table back to my Access db. Then using that linked table to update the data so that it will appear on the Sharepoint site...correct?

Isn't there a way to just tell the Sharepoint site to pull the data directly from the access table that I already have setup?

Travis
www.apexsystemsinc.com
 

RE: Displaying Access Data on Sharepoint

I could be wrong but this is how I see it.

1) Create a Data View in SharePoint Designer that uses your Access DB as a data source.

2) Link to a SharePoint List from Access. Then populate that linked List with your Access data. (append query)

3) Setup a BDC connection from SharePoint to Access.

 

http://www.sharepointed.com/

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close