Question Locked

How can I transfer data from Linux database to Microsoft Access?

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I want to be able to extract the data stored on the Linux server and display it in Access.

7 replies

by valengrey

The Red Hat Linux server is being used to run SCADA in a PRISM environment. The database it uses is a proprietary database for Advance Control Systems.

by oh smeg

Open your M$ Program and try importing the File from the server if that is where it is.

Col

by tony hopkinson

My experience in the past with SCADA and PLC based systems is you have to rely on the vendor to produce the acess unless they have chosen to use someone else's db tech. Rockwell Automation for instance allowed you to record data and events from PLCS and SCADAs in a database/file of your choice. So if you chose to do it in say Oracle, or MySQl, then you could use their drivers to access whatever you stuck in there. I'd be shocked if your vendor can't sell you some expensive and probably inefficient way of doing it.

by brenton keegan

But it would seem your best bet would be to try to find an ADO driver. This will allow your VB code to connect to this database.

by nadiasz

You can try to create ODBC data source (select dBase driver), then create linked table in MS Access that connects to that DSN.

This discussion is closed to new replies.