5/21/2012 8:39 AM | |
Joined: 11/4/2011 Last visit: 8/25/2024 Posts: 253 Rating: (53) |
Hello osk, have you seen this FAQs? How do you log tags in an SQL database and read them out again with WinCC flexible? How can you store tags/data records event-triggered with date and time in a CSV file? Very useful. I'm studying it at the moment, so maybe I would help you more and give some examples of mine, later. And Flexible online help has some examples relating writing to excel: CreateObject Function topic Best regards. ___________________ Do you really need to import data to Flexible RT from SQL Server? Maybe it's enough to work just in Excel, to import a hole table from SQL Server and apply time filters. Or make SQL query and get only the data needed. But if you need to generate Excel files automatically with some period I'd agree that the easiest solution is Flexible's Scheduling and Exporting job to Excel. |
Last edited by: TerminalBuzz at: 5/21/2012 10:53 AM |
|
This contribution was helpful to1 thankful Users |
5/22/2012 1:19 PM | |
Posts: 6 Rating: (0) |
tahnksTerminalBuzzfor your reply......... I read this particular example and with the help of same I can able to generate/ store my data in SQL server. But what I need is, want to generate an excel sheet for this data. I tried different options to generate an excel sheet of SQL server data but couldn’t successes. So I am requeting you all if any of you have anyIdea regarding exporting SQL data in Excel format through VB Scripts then please help....... Regards Omkar Kamalapurkar |
10/7/2018 12:41 PM | |
Posts: 1 Rating: (0) |
I'm also facing the same problem. Unfortunately, due to some reason i would not able to transfer data to excel.
Rumi Moula |
Follow us on