Inserting BMP image stored in sql database into Excel

[vambam]

Hi,
Using the following code I can get the logo to appear in Excel. This same logo is stored in a SQL Server database as a general type column for each company and I would like to issue from within foxpro, a SQL select statement to retrieve the value and insert it into Excel.
The application folder is stored on several servers and it would be much easier to maintain if it's pulled from SQL using Foxpro and inserted into Excel
Sample of Existing Code:
LogoFile = "C:\Apps\AM\BITMAP\LOGO01.BMP"
*oExcel.activesheet.Shapes.AddPicture(LogoFile,.F.,.T.,32,32,72,72)
oExcel.activesheet.Shapes.AddPicture(LogoFile,.F.,.T.,0,0,36,36)

Any tips on how to accomplish this would be greatly appreciated.

TIA,
Doug

 

[white605]

As has been reccomended here many times, i would consider putting all the bmp's on the local machine first, then building a lookup table with a reference field for lookup and a filename field - use that to feed your automation.