Importing Image Data

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 named image run bcp as follows:

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

Answer the prompts bcp presents as follows:

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

In this example, 5578 is the length of the file. The file will be loaded into column c1.