Hi,

I have a vbscript program that is connected to MS SQL Server 2000. Now, i
would like generate a report which contains some pictures. However, the
image field datatype stored in binary format, not physical path, how can i
insert the image to Excel.

Best Regards,
Sexball

Hi all,

I'm not using vbscript, i'm using MS visual basic

Best Regards,
Sexball



"sexball" bl...
Hi,

I have a vbscript program that is connected to MS SQL Server 2000. Now, i
would like generate a report which contains some pictures. However, the
image field datatype stored in binary format, not physical path, how can i
insert the image to Excel.

Best Regards,
Sexball

The simplest procedure is to transfer the .bmp file to the computer and to
insert it with:

ActiveSheet.Pictures.Insert( _
"C:\Documents and Settings\Owner\Desktop\Blue Lace 16.bmp").Select

You can use other code to position and size the picture.
--
Gary''s Student


"sexball" wrote:

Hi,

I have a vbscript program that is connected to MS SQL Server 2000. Now, i
would like generate a report which contains some pictures. However, the
image field datatype stored in binary format, not physical path, how can i
insert the image to Excel.

Best Regards,
Sexball