INF: Using BCP to Import Image Data into SQL Server

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:

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.