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

By valengrey ·
I want to be able to extract the data stored on the Linux server and display it in Access.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

What database

by Tony Hopkinson In reply to How can I transfer data f ...
Collapse -


by valengrey In reply to What database

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.

Collapse -

Well I suppose the obvious is to

by OH Smeg Moderator In reply to ACS

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


Collapse -

Hmm can't find much about that.

by Tony Hopkinson In reply to ACS

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.

Collapse -

I don't know much about this

by Brenton Keegan In reply to ACS

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.

Collapse -

Create Linked Tables

by NadiaSz In reply to How can I transfer data f ...

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

Related Discussions

Related Forums