How can I export a image from Excel

[karenros]

I want to export images from Excel to sql server or access..

Can someone please give me a link or the steps to do it..

Any help will be appreciated.

Thanks,
Karen

[Kenneth Hobs]

Not sure what you need. Are these pictures in Excel? In this example, I saved the Image1 on Sheet1 to a file. I then loaded it into a picture object on a userform.
Private Sub UserForm_Initialize()
Dim s As String
s = ThisWorkbook.Path & Application.PathSeparator & _
Image1.Name & ".bmp"
SavePicture Sheet1.Image1.Picture, s
Image1.Picture = LoadPicture(s)
End Sub

If you can attach a very simple xls and mdb file, it might be easier to help.

[karenros]

Kenneth,
Thanks for your reply.. Yes my images are in excel
My excel spread sheet has the following
PlanId PhoneInfo MessageBoard Logo
1214 123-453-7890 messageboad Picture
1412 456-754-7423 different message anotherPicture..


So i want to load all of this data from the excel spread sheet to sql server.. I know how to import the text part and

just had trouble importing the Picture.. I can try ur logic and sees if it works..

Thanks,
Karen