Image storage in SQL Server

[Geunther]

I have a project that needs to store images from an excel worksheet to a SQL database. I only have VBA as a tool to accomplish this. I have code to identify all the images on the worksheet that are of picture type. I have the connection strings developed, and am able to write data to the database. My road block is the conversion from an image file (jpg, gif, bmp, etc) to the image datatype in the SQL database. I am aware of the issues with image storage in SQL, but I am also sure this is the best method for this project. I am using excel as the front end to the database, with VBA as the engine to collect and store the data. Excel is not my vehicle of choice, but it is my directive. If this is not the correct forum, please feel free to direct me to a more appropriate location. Thanks in advance.

[debasisdas]

this thread might be helpful for you.

[Geunther]

this thread might be helpful for you.

thanks, I found it after my post, and am investigating using the code posted.