INF: Using BCP to Import Image Data into SQL Server

ID: Q69286

The information in this article applies to:

Microsoft SQL Server versions 4.2x, 6.0, 6.5, 7.0, 7.0 Service Pack 1

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 : winnt:4.2x,6.0,6.5,7.0,7.0 Service Pack 1
Platform : winnt
Issue type :