Preston Kemp wrote:
> lbunet_at_yahoo.com wrote:
>
>
>>Vince wrote:
>>
>>>Hello there!
>>>
>>>I would like to mass load data from file to table..
>>>is there any way such as 'bulk insert' in sqlServer ?
>>>
>>>thanks a lot :)
>>>++
>>>Vince
>>
>>exec master..xp_cmdshell 'bcp {database}..{table} in
>>c:\{File_w_Data}-c -S{ServerName} -U{Username} -P{User's password}'
>>
>>You can also user BULK INSERT (See BOL for syntax).
>>
>>In the future, please post to the appropriate group
>>(comp.databases.ms-sqlserver).
>
>
> I think he did post to the appropriate group - I read it as 'is there
> an equivalent to SQL Server's bulk insert command in Oracle'.
I too suspect that was the intent but it is not what was written.
The OP needs to repost.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Tue May 10 2005 - 14:56:01 CDT
