ID Number: Q69286
1.10 1.11 4.20
OS/2
Summary:
You can use BCP to copy a file as image data into 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 reference words: bulk copy 1.10 1.11 4.20