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, "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)