Problem Accessing My Local A: Verses The SQL Servers A: Drive

I am having a problem accessing my local A: drive, using the bulk insert command. The actual sql server pc thinks I am accessing its sql server's A: and not my local a: drive. I am trying to read in a simple CSV delimited ascii file into a sql table. Wow what a nightmare just to read a simple ascii file into a table. Unfortunatley I am writing a program in VB.net for an operator to import ascii data from floppy diskettes.

I am using this command below: The command works fine but I have to go to the actual server and put the floppy disk in over there. I want the operator to be able to use there own A: or any location drive for that matter. Sql server over the network is not allowing us to access any local drive to import this data. I get an error 21 because the sql server does not have the floppy in its drive. It seems like some kind of security issue, but I am not sure. Any information would be most appreciated in this matter. Thanks in advance.

Sarah Diane Reid

sample code below:

BULK INSERT Master.dbo.imVBMbAddress

FROM 'a:mbAddressPipes.txt'

WITH (FORMATFILE = 'a:importdatambaddress.fmt',

FIRSTROW=2);