INF: Using BCP to Import Image Data into SQL Server (69286)
The information in this article applies to:
- Microsoft SQL Server 4.2x
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
- Microsoft SQL Server 7.0
- Microsoft SQL Server 7.0 Service Pack 1
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)
- Enter the field terminator [none]:
The file will be loaded into column c1.
| Modification Type: | Minor | Last Reviewed: | 2/14/2005 |
|---|
| Keywords: | KB69286 |
|---|
|