[Imported] Export and import data from a file XML (EXCEL)

[sbeadle]

>>Message imported from previous forum - Category:Scripts and Tips<<
User: mchartrand, originally posted: 2018-10-25 19:18:49 Id:277
This is a re-posting from the obsoleted (October 2018) "Schneider Electric Telemetry & SCADA" forum.

_______

**_PavelUKR:
Hi, all! Please, prompt the easiest way to export and import data from a file XML (EXCEL). Thanks._**

______________

bevanweiss:
What kind of data are you talking about?
I assume you mean historical data, in which case writing some VBA using the DBClient.DLL is the way most people go about it.

You find your point, and then you can either LoadDataValue(s), or you can set the PresetTimestamp / PresetQuality and then the CurrentValue field.

Exporting to Excel format is best done using the Crystal Reports engine.
It is also possible to use an SQL Export, however it doesn't allow as much accusation.

____________________________

**_PavelUKR:
Thank You for response. I try use ODBC query for my task. But I don't know, how write SQL query. Maybe is it wrong way?_**

______________________________

**_PavelUKR:
A solution is found!_**