"Star" <nospam@nospam.com> wrote in message
news:%23HnbWahxEHA.3212@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I'm trying to make a bulk insert from a client computer that is connected
> to a SQL Server.
> However, I have noticed that the files that I want to import need to be on
> the server, instead of the
> client. You may not have windows access to the server machine, so I don't
> see the point of copying all the files to the server before importing the
> data.
>
> My question is: Is there anyway to import the files directly from the
> client?
>
> Thanks
>
>
>

"Star" <nospam@nospam.com> wrote in message
news:O6XkHXixEHA.1452@TK2MSFTNGP11.phx.gbl...
> Hari, thanks for your answer.
>
> I'm sorry for my ignorance, but what do you mean with YourPCShareName?
>
> I just need to import the file which is located in the same folder where
> the client is running (a regular .exe application)
>
>
>
> "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
> news:e$fpZKixEHA.1392@TK2MSFTNGP14.phx.gbl...
>> Hi,
>>
>> Yes you can. Provide the UNC name along with the file name
>>
>> BULK INSERT dbo.MyTable FROM '\\YourPCName\YourPCShareName\YourFile.txt'
>>
>> --
>> Thanks
>> Hari
>> SQL Server MVP
>>
>> "Star" <nospam@nospam.com> wrote in message
>> news:%23HnbWahxEHA.3212@TK2MSFTNGP09.phx.gbl...
>>> Hi,
>>>
>>> I'm trying to make a bulk insert from a client computer that is
>>> connected to a SQL Server.
>>> However, I have noticed that the files that I want to import need to be
>>> on the server, instead of the
>>> client. You may not have windows access to the server machine, so I
>>> don't see the point of copying all the files to the server before
>>> importing the data.
>>>
>>> My question is: Is there anyway to import the files directly from the
>>> client?
>>>
>>> Thanks
>>>
>>>
>>>
>>
>>
>
>

"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:e$fpZKixEHA.1392@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> Yes you can. Provide the UNC name along with the file name
>
> BULK INSERT dbo.MyTable FROM '\\YourPCName\YourPCShareName\YourFile.txt'
>
> --
> Thanks
> Hari
> SQL Server MVP
>
> "Star" <nospam@nospam.com> wrote in message
> news:%23HnbWahxEHA.3212@TK2MSFTNGP09.phx.gbl...
>> Hi,
>>
>> I'm trying to make a bulk insert from a client computer that is connected
>> to a SQL Server.
>> However, I have noticed that the files that I want to import need to be
>> on the server, instead of the
>> client. You may not have windows access to the server machine, so I don't
>> see the point of copying all the files to the server before importing the
>> data.
>>
>> My question is: Is there anyway to import the files directly from the
>> client?
>>
>> Thanks
>>
>>
>>
>
>