Use Access as External Data
1. Enter Excel server management Console, select "External Data", click right mouse key, choose "New-Data Source" in the pop-up:
2. Fill the textbox:
Data Source Type selects Access.
Data Source Name : NorthWind.
3. Click 
, choose the data file as External Data:
4.Click "Open":
5. Click "Ok".
6.Click the table required to use in excel server, choose "Add table":
7.Set "Displayed Name", "Display Column Name" and "Primary Key":
Displayed Name is the name of data table in Excel Server.
Actual Column Name is the name in MS Access
Data Type is the data type in MS Access.
Required is "Required" of Column in the table in MS Access:
Display Column name is the name of field in excel server.
Primary Key must be set as the primary key in excel server data table.
8. Set "Reading Authority":
Note:
1. Write and Mapping can be set only on non-view tables.
2. If ExcelServerRCID and ExcelServerRN are added in non-view table, mapping can be set in this table only.
8. Click "OK":
