Monday, March 26, 2012

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:
>
> I believe Access needs to be installed on the computer where the
> import process executes.
> Roy Harvey
> Beacon Falls, CT
>

No comments:

Post a Comment