Import from MS Access to SQL 2005 problem

I can not import a MS Access database into a SQL Server 2005 database on the
SQL Server 2005 server where MS Access is not installed but I can import it
from a Citrix computer where MS Access is installed.
Is there a requirement that MS Access has to be installed on the computer
where you want to load the Access database from ?
I get the following error when I try from the Server where MS Acces is not
installed:
Could not retrieve table list.
Could not load file or assembly 'System.Enterprise.Services.Wrapper.dll' or
one of its dependencies. The system cannot find the path specified.........
Thanks.On Thu, 21 Jun 2007 07:10:00 -0700, DXC
<DXC@.discussions.microsoft.com> wrote:
>Is there a requirement that MS Access has to be installed on the computer
>where you want to load the Access database from ?
I believe Access needs to be installed on the computer where the
import process executes.
Roy Harvey
Beacon Falls, CT|||Thanks............
"Roy Harvey" wrote:
> On Thu, 21 Jun 2007 07:10:00 -0700, DXC
> <DXC@.discussions.microsoft.com> wrote:
> >Is there a requirement that MS Access has to be installed on the computer
> >where you want to load the Access database from ?
> I believe Access needs to be installed on the computer where the
> import process executes.
> Roy Harvey
> Beacon Falls, CT
>