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 strongm 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
- Thread starter GerryML
- Start date
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.
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.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
