Re: Recommended Procedure for Importing From Access Across LAN

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Stefan Berglund (keepit_at_in.thegroups)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 09:19:47 -0800

On Wed, 24 Mar 2004 18:00:58 -0800, Stefan Berglund <keepit@in.thegroups> wrote:
 in <a5e460938kcjpl8otanm1v80lu5mfveni7@4ax.com>

>I seem to be having difficulty importing data from an Access db
>when it's other than on the server. I can create a linked server
>if the db is on the server, but otherwise not (as per BOL).
>
>How should I move the file to the server?
>
>Does SQL Server contain any facility for moving a file across the
>LAN to the server? I've tried:
>
>xp_cmdshell 'copy ''\\stefs-chrysler\My
>Documents\ShowTime\Test\Arbutus_0313.mde'' ''C:\'''
>
>but I get:
>
>The system cannot find the path specified.
>NULL
>
>but the path exists and opens in Windows Explorer.

The problem was the space in the UNC path. This works:

xp_cmdshell 'copy "\\stefs-chrysler\My Documents\ShowTime\Test\Arbutus_0313.mde" C:\' 

---
Stefan Berglund
first shift-minus last a t m s n d o t c o m
Quantcast