does anybody have experiance with importing the PI Audit Data into SQL Server? I have exported the data (for the last five years) from the dat files into XML Files. My first attempt was to import them into Excel so that I will be able to import them easyly into SQL Server. But they are much too big for Excel (and most of them even for several text editors).
So I need to import the xml files directly into MX SQL Server. But I´m not so experianced with MS SQL Server so I would be happy if someone has done this before so that I can participate from the experiance.
Or maybe there is another way to get the data into SQL server wthout first exporting XML files.
Loocking forward to hearing form you!