Transfer results from SQL to Excel sheet

[LV2020]

Hi Everyone, I am trying to create a VI that saves SQL database for certain table to excel sheet.

I tried to connect the DB results to Write DlimitedSpreatsheet, but it displays broken arrow (Different data type). I attached the VI

I tired using (Variant To Data Function ,Variant to Flattened String, Flatten to String Function, and Flatten To JSON function) to convert data before creating the excel sheet, but it did not work. 

It shows either a broken arrow or unknown characters.

Any suggestions?

, 

[K C · Accepted solution]

Hi,

The Data from the Database VI is of the Variant type. You convert this before you can use it to rite to a file.

Here it is coverted to sa 

 

[LV2020]

Thanks!