How to save an image from SQL Server to MS Access .mdb
I have a SQL Server database with a table that has a column that stores an image. I have another database and I would like to store the image from the SQL Server database into it. It's type is MS Access 2000 format .mdb.
The problem is I get back the content of the column and I put them in an array of bytes as follows:
Dim arrByte() As Byte = CType(dtAll.Rows(0)("DailyProgram_Image"), Byte())
It sends me back the data of the image as byte type. When I try to save this into the access DB it give me an error because of type mismatch.
Codeproject has an article about uploading and downloading BLOBs to Access here http://www.codeproject.com/KB/database/AccessBlob.aspx