INF: Using BCP to Import Image Data into SQL Server| Article ID | : | 69286 | | Last Review | : | February 14, 2005 | | Revision | : | 3.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.
APPLIES TO| • | Microsoft SQL Server 4.21a Standard Edition | | • | Microsoft SQL Server 6.0 Standard Edition | | • | Microsoft SQL Server 6.5 Standard Edition | | • | Microsoft SQL Server 7.0 Standard Edition | | • | Microsoft SQL Server 7.0 Service Pack 1 |
 Back to the top
| Other Support Options - Contact Microsoft
Phone Numbers, Support Options and Pricing, Online Help, and more. - Customer Service
For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more. - Newsgroups
Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.
|
|
