CREATE TABLE [dbo].[tblClientPersonalInfo](
[PersonalInfoId] [bigint] NOT NULL,
[FolioGroupNo] [bigint] NULL,
[ClientId] [bigint] NOT NULL,
[IndentityStatus] [varchar](50) NULL,
[RelationshipId] [bigint] NOT NULL,
[Title] [varchar](30) NULL,
[FirstName] [varchar](100) NULL,
[MiddleName] [varchar](100) NULL,
[LastName] [varchar](100) NULL,
[Gender] [varchar](10) NULL,
[DateOfBirth] [datetime] NULL,
[HealthStatus] [varchar](50) NULL,
[IssueDetails] [varchar](max) NULL,
[Occupation] [varchar](50) NULL,
[MobileNo] [bigint] NULL,
[EmailId] [varchar](200) NULL,
[Address] [varchar](500) NULL,
[City] [varchar](50) NULL,
[State] [varchar](50) NULL,
[Country] [varchar](50) NULL,
[PinCode] [bigint] NULL,
[PANNo] [varchar](50) NULL,
[MaritalStatus] [varchar](50) NULL,
[MarriageAnniversary] [datetime] NULL,
[ResidentialStatus] [varchar](100) NULL,
[FinanciallyDependent] [bit] NULL,
[PhotoPath] [varchar](200) NULL,
[HeaderCoverPage] [varchar](200) NULL,
[IsImported] [bit] NULL,
[UserIdCreated] [bigint] NULL,
[UserIdMaintain] [bigint] NULL,
[CreatedDate] [datetime] NULL,
[ModifiedDate] [datetime] NULL,
CONSTRAINT [PK_tblCustomerPersonalInfo] PRIMARY KEY CLUSTERED
)
From this SQL table I have to generate the Excel sheet.
how to do this?