Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Storing an Image in SQL Server 7

Status
Not open for further replies.

GerryML

Programmer
Feb 20, 2002
8
US
I have a table in sql server 7 and a field is datatype of image. How do I insert / store an image in the table?
-gerard
 
Hi,

You need to write the image in from the front end whether it be VB or Access or another, there is no way I know that you can do it with SQL itself, you could possibly break it into binary objects (BLOB) and write it into the field a bit at a time.

The Northwind Access front end Employees form has an example of Image - link it to the SQL Northwind Demo.

Cheers Dave Dave
dab@completebs.com
See website for more info but we can develop most things for most people.
 
how can i use ado to do store the image? can u please give me a quick example please?

-gerard
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top