The Office ACE provider is used to import from text files, Excel
files, and Access files.  Just like for any data provider, you
need to install the provider on both the client side (machine
with BIDS) and on the server side (both the machine running the
workspace DB instance and the machine running the deployment DB
instance). The reasons for this are explained in the
impersonation documentation. The BIDS client uses the data
provider (and the current user’s credentials) for Preview and
Filter, Edit Table Properties, and Partition Manager operations.
The server requires the data provider for processing (both at
import time and processing time).  There are two ways to get the
ACE provider:    1. Install Office (which includes the ACE
provider)   2. Download the ACE provider from the download
centre  But before you run off and get the provider for the BIDS
machine, you need to decide which version of the provider to get
– 32 bit or 64 bit. The ACE provider doesn’t support side-by-
side installation of the 32 bit