Access database importing Excel file both in SharePoint

Asked By Mauricio Chacon
18-Nov-09 12:56 PM
Earn up to 0 extra points for answering this tough question.
Hello All
 
I uploaded two files into SharePoint (Shared Documents), I use Excel 2007 file to input data, then I open the Access 2007 and import the info inputed on above mention Excel 2007 file.
 
Import steps: On Access 2007 database uploaded into SharePoint and saved in drive C, I need to import an External data/SharePoint List (Import Sharepoint List), from an Excel 2007 file uploaded to same Sharepoint. Finally press Publish Changes (Save your changes to the server/ Publish to SharePoint Site).
 
Can I do that? I tried as External data Excel (Import Excel Spreadsheet) without results.
 
 
Best regards.

  re: Access database importing Excel file both in SharePoint

Frank Daske replied to Mauricio Chacon
14-Mar-10 05:33 AM
You can connect any SharePoint list directly to external data (including Excel or Access) in the list settings dialog with this 3rd party solution Business Data List Connector:

http://www.layer2.de/en/products/pages/sharepoint-business-data-list-connector.aspx

The following settings should be applied:



All list features are available. There is a free Shareware version.

Cheers, SharePointFrank

Create New Account