200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
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?
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.
