INF: Using BCP to Import Image Data into SQL Server

Last reviewed: April 25, 1997
Article ID: Q69286

The information in this article applies to:

  - Microsoft SQL Server version 4.2 for OS/2
  - Microsoft SQL Server version 4.2

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, "Image" 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 : kbtool SSrvBCP SSrvWinNT
Version : 4.2 | 4.2
Platform : OS/2 WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 25, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.