Importing Data from CLX To Excel

kf5pv

Member
Join Date
Aug 2008
Location
Fort Worth
Posts
39
Is there an easy way to import data from a Control logix to Excel 2007 without using RS linx? I used to do this with some PLC 5's over the office network and bridged to the plc network. It was an older version of Excel I was using but Im not understanding how I can do this in Excel 2007 without running RS Linx on the computers I am wanting to use the spreadsheet on. Im not a real big clx user or intergrator so I hate to ask these questions.
Thanks for any suggestions.

In God we trust. All others must bring data.
 
Last edited:
You will need Linx. I would be surprised if you could ever have extracted data from an Allen Bradley PLC without Linx. Unless of course you wrote a driver to communicate with the PLC5.
 
Last edited:
I agree. I got a CLX talking with an excel spreadsheet through Linx right now. I also have a PLC 5 talking to VB5 and a SLC 5/04 talking to VB6. One of those don't use Linx at all, but a program called ABDF1 Parijat.

Not to be nosy but if your looking at doing VB code in the excel environment, keep looking, nothing but trouble. Go with SQL Server.
 
You will need Linx. I would be surprised if you could ever have extracted data from an Allen Bradley PLC without Linx. Unless of course you wrote a driver to communicate with the PLC5.

Yes I did do this before. Excel actually recognized the processor and ask me what interger files I wanted to export from. i think I just used a web quary and put in the path with the IP adresses.
 

Similar Topics

Long time member, first time poster. Last night our plants wireless network died, shutting the whole plant down. As a result, I have been tasked...
Replies
3
Views
1,534
Is it possible to import trend data into an existing project? I have previous trend data and would like to import it into the current project.
Replies
1
Views
2,023
Hi, I am just new in automation field. Actually we use compact logix 1769 L32E PLC which already have Ethernet port. We also use MODBUS RTA...
Replies
2
Views
4,089
Using RSLogix 5000, using FactoryTalk View Studio. Im learning here and my eyes are crossing. Trying to import the tag database of a Logix...
Replies
7
Views
2,898
Hi everyone, I would like to use data from another, custom program, in Unity Pro. The program saves a list of Real numbers which represent the...
Replies
1
Views
3,580
Back
Top Bottom