How to put database output into excel

Help Activities
, ,
1

I use connect function to database, and want the output in excel

3

Hi @Nightowl_music,

You can write output from query after connect activity to excel using ‘Write range’ activity.

Also please change the tags of this topic, its more of a question than feedback. Right tags helps your topic gain right traction:)

Regards
Sonali

4

@Nightowl_music

After connect activity use Execute NonQuery activity and write your sql expression like Select * from TableName, In the properties create an output variable which will be a Datatable

Then use Write Range activity and pass the Datatable variable

You can see the output in Excel

Hope this may help you

Thanks