Hello to all,
I´m using an old DeltaV Client V7.4.1 on a Windows Server 2003 (Standard Edition) system and I want to export the project data to MS Access, because of writing a tool later to analyse the data. I actually exported data to an .fhx file with and opened it with MS Excel or Editor, but I need the Data in MS Access, otherwise I would have to write another tool to transfer the data to Access.
I saw that there should be a possibility to export data to ODBC. I have created an access-database and linked it with a dsn-file in the control panel/Administrative Tools. Then I tried to export with DeltaV Explorer/File/Export/user defined > ODBC, I selected my dsn file, but then I couldn´t select one of my databases in the dropbox, I can only select "MsysAccessObjects"(before I installed MS Office it was the same!). I think MsysAccessObjects is an access-system-database.
When I first worked with it there was no MS Office on the System, so I installed MS Office 2003 later. I have read that the later installation might make problems, maybe the Version is not compatible with DeltaV V7.4.1.
So you see I have a lot of questions:
Is there a possibility to export my data to MS Access?
Is the version of MS Access compatible with my DeltaV version or can I get the information anywhere in my System? Maybe I can get another version of MS Office if necessary.
Thanks for your answers,
best regards, Chris