INF: Using BCP to Import Image Data into SQL Server

ID: Q69286

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.2
Microsoft SQL Server version 4.2x

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 
Issue type        :

Last Reviewed: March 10, 1999