Help
Help
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
80820members
346892posts

SQL to CSV trend

Back to Industry Automation and Control Forum
energima
Ensign
Ensign

Posted: ‎2021-04-16 12:48 PM . Last Modified: ‎2021-04-16 12:49 PM

0 Likes
2
613

Posted: ‎2021-04-16 12:48 PM . Last Modified: ‎2021-04-16 12:49 PM

SQL to CSV trend

I need help. to export my trend in SQL db to CSV. 

Someone can help me with this.

 

In machine Scada expert 2021

Tags (1)
2 Replies 2
Rodrigo_Garcia
Administrator Administrator
Administrator

Posted: ‎2021-04-27 02:13 AM

0 Likes
0
569

Posted: ‎2021-04-27 02:13 AM

Re: SQL to CSV trend

Hello @vitor_mendes : Could you support on this? 

Regards,

Rodrigo G. 


Industrial Automation Community manager

Tags (1)
energima
Ensign
Ensign

Posted: ‎2021-04-27 07:59 AM

0 Likes
0
560

Posted: ‎2021-04-27 07:59 AM

Re: SQL to CSV trend

i find a way but not shure if it's the best and simple way.

 

I use $Exec ("CMD /C sqlcmd -S  .... )

 

And after this i need to send the file by email with the $SendEmailExt. 

 

It's working but you need to make a lots of code to do it nice 

 

Tags (1)
Invite a Colleague
Found this content useful? Share it with a Colleague!
Invite a Colleague
Support

Have a question? Please contact us with details, and we will respond.

Contact Us
FAQ

Look through existing questions to find popular answers.

Learn More
About

Want to know more about Exchange and its possibilities?

Learn More