SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

Microsoft sql server 2005 database datalog value to excel

6/11/2011 9:13 AM	Rate (0)
viralpatel Posts: 523 Rating: (32)	Dear Experts, thank you, i have successfully logged variable value to MS sql server database table via WinccFlexi RT PC. now I want to move this logged data to Excel to make user readable report how can i do that. viral patel
viralpatel Posts: 523 Rating: (32)
Suggestion To thank Quote Answer

6/13/2011 6:45 AM	Rate (0)
R J Posts: 215 Rating: (12)	Hi Viral, Instaed of logging variables in Sql server 2005, you can select CSV file as a option for logging variables. Because CSV file can be open in EXCEL. By using VB-Script or Macros in Excel, you can make a User readable report also.
R J Posts: 215 Rating: (12)
Suggestion To thank Quote Answer

6/13/2011 1:50 PM	Rate (0)
JaToLe Posts: 11 Rating: (0)	I think making a macro handle a csv file seems like an awkward way to make a report. (Unless you are much better at programming excel macros than at handling databases.) The simplest way, I think, would be to make a database query in Excel: Data -> Import External Data -> New Database Query. Once youget the data into Excel, you can format it, make graphs or whatever you like to have in the report.If the query is complex (grouping, filtering, calculations rather than a plain "SELECT ALL x FROM y"),you may want to either make an ODBC data source or set up a query in your database, to simplify things in Excel. You could also use the database functions in Excel: DAVERAGE, DMIN, DMAX, DSUM etc. The upside is that using these functions make it easier to design exactly what data goes in which cell, butit is often tricky to getthe Excel database functions right.
JaToLe Posts: 11 Rating: (0)	Last edited by: JaToLe at: 6/13/2011 5:30 PM
Suggestion To thank Quote Answer

6/14/2011 6:36 AM	Rate (0)
viralpatel Posts: 523 Rating: (32)	Dear JaToLe, i want to know that normal Sql Commands can work for accessing database of sql server to Excel. and one more thing what about if we want daily report base excel file saving. if any help file for sql command function for excel please send it so i can thoroughly refer it. viral patel
viralpatel Posts: 523 Rating: (32)
Suggestion To thank Quote Answer

6/15/2011 12:10 PM	Rate (0)
JaToLe Posts: 11 Rating: (0)	Dear viralpatel, Excel database querys uses standard SQL. Database functions are used for data that is already in the same Excel file, and they do not use SQL.(This is onereason I think the functions are tricky and awkward.) I think the Excel help would be the best way to get more info, "SQL" and "database" might be good search terms. This is a link to a tutorial about importing data to Excel: http://office.microsoft.com/en-gb/excel-help/import-data-import-external-data-into-excel-2003-RZ001183132.aspx?CTT=1&origin=EC001022984 As a general guideline, you should try to make the SQL query as close as possible to what you want in the report. To first "SELECT ALL", and then do the filtering and grouping in Excel is usually mor difficult than to edit the query. Hope this makes sense and helps you. //JaToLe ------------------------------------------------------------------------------------- Maybe a csv archive isn't as difficult to use as I thought, check out this thread: problem of wincc flexible archive The FAQ link posted by Ayman Elotaify was interersting news to me.
JaToLe Posts: 11 Rating: (0)	Last edited by: JaToLe at: 6/15/2011 4:43 PM Added comment about csv archive
Suggestion To thank Quote Answer

Share this page:

Share this page on...