Microsoft KB Archive/69286

= INF: Using BCP to Import Image Data into SQL Server =

Article ID: 69286

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 7.0 Service Pack 1

-



This article was previously published under Q69286



You can use BCP to copy a file as image data into Microsoft SQL Server. For example, to load the file TEST.DOC into a table, &quot;Image&quot; run BCP as follows:

bcp pubs..image in test.doc -Usa -P -Ssvr

Answer the prompts to BCP as follows:


 * Enter the file storage type of field c1 [image]: [Enter]
 * Enter the prefix length of field c1 [4]: 0
 * Enter length of field c1 [4096]: 5578 (the length of your file)
 * Enter the field terminator [none]:

The file will be loaded into column c1.

Additional query words: bulk copy Windows NT

Keywords: KB69286

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.