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 named image run bcp as
bcp pubs..image in test.doc -Usa -P -Ssvr
Answer the prompts bcp presents as follows:
Enter the file storage type of field c1 [image]:
Enter the prefix length of field c1 : 0
Enter length of field c1 : 5578
Enter the field terminator [none]:
In this example, 5578 is the length of the file. The file will be loaded
into column c1.
Spectrum Technology Group NTP
MCSE, MCSD, MCT, SQL Server MVP
President: Capital Area SQL Server UG
Quote:> Would someone kindly post the correct syntax to insert an image field
> (image datatype) on MS SQL Server 6.5? For example, suppose I have
> MyPic.jpg stored locally on the SQL Server, with a path of
> C:\Images\MyPic.jpg. How would one insert that jpg file into an image
> field in an SQL Server table?
> Thanks in advance!