extract image from varbinary(max) in sql server

0

I have a table in sql server with the following structure

CREATE TABLE [dbo].[PHOTO] (

[PHOTOID] int IDENTITY(1, 1) NOT NULL,

[PRODUCTID] nvarchar(255) NOT NULL,

[COMMENTS] nvarchar(2000) NOT NULL,

[PHOTOBASE64] varbinary(MAX) NULL,

[DATECREATED] datetime NULL)

ON [PRIMARY]

TEXTIMAGE_ON [PRIMARY]

WITH (DATA_COMPRESSION = NONE);

I want to extract the data into excel.

Has anyone a working example?

Answer
Discuss

Answers

0

In Excel, go to the Data tab and click From Other Sources on the left and then From SQL Server and a connection wizard will walk you through some steps to get data from sql server.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login