Convert JSon value to column header

[SonOfJeffGoldblum]

I have a SQL Server loading a column, AnswersJson and would like to convert the values within Question to be a column header with the AnswersJson portion "AnswerText" to associate with that column.

Id	Question	QuestionNumber	AnswersJson	CreatedDate
1	How was your service	5	[{"AnswerPart":null,"AnswerColumn":null,"AnswerText":"Great","AnswerOther":null,"AnswerExportValue":"","AnswerComment":null}]	7/29/2019
2	How could we have done better	6	[{"AnswerPart":"","AnswerColumn":"","AnswerText":"service time","AnswerOther":null,"AnswerExportValue":"","AnswerComment":null},{"}]	7/29/2019
3	Would you recommend us	7	[{"AnswerPart":null,"AnswerColumn":null,"AnswerText":"yes","AnswerOther":null,"AnswerExportValue":"","AnswerComment":null}]	7/29/2019
4	Do you have any questions	8	[{"AnswerPart":null,"AnswerColumn":null,"AnswerText":"No","AnswerOther":null,"AnswerExportValue":"","AnswerComment":null}]	7/29/2019

Expected Result:

Id	How was your service	QuestionNumber	CreatedDate
1	Great	5

Thank you

[SonOfJeffGoldblum]

When I load data, I get "No qualified path for file" error.