You can enter values which you wish to place in a particualar memory location from that file within RSLogix, however, this can get really tedious if you have a lot of numbers to enter, say for a very long sequencer or a large look up table or large recipes.
To avoid the tedium of entering the information by hand, or having to go online and use DDE, you can do the following:
Click File->Save As. Change the file type to SLC library file, and save the program. Now open the .SLC file in notepad or other suitable asciConnection: closei editor. As you scroll down you will see all of your ladders and descriptions in menumonic text. Scroll past the ladders and you will come to the data files.
You will see some sections that look like this:
DATA N210:0
% N210:0 % -31 559 0 0 203 1 2 0 0 0
% N210:10 % 0 100 15 10 22 -22 15 240 682 -1
% N210:20 % -354 146 0 0 2457 22 85 400 75 0
This is an N210 file I grabbed from a SLC inport of one of my programs. Note how it is formated - and have a look around the .SLC file to understand how they are set up.
Now using excel, generate the large data file in the same format, and save it as a space delimited text file. Don,t forget to include the header to identify the file and type. Open that file in wordpad now. You should have a file that looks something like what I pasted above. Now go back to the original file and copy/paste in the first line of the fiConnection: closele. You have to have at least rung run in a SLC library file, so come down to file 2 and cut/paste the first rung and copy it over to the new file. Save that file with the .SLC extension.
Your file will look like this:
START 1747-L552B % 1747-L552B 5/05 CPU - 32K Mem. OS501 Series C %
LADDER 2
% Rung: 0 %
SOR XIC S:1/15 JSR 101 EOR
DATA N250:0
% N250:0 % 0 10 20 30 40 50 60 70 80 90
% N250:10 % 100 110 120 130 140 150 160 170 180 190
% N250:20 % 200 210 220 230 240 250 260 270 280 290
Now open RSLogix and the program in which you need the data. (Make sure you have a backup first just in case) Go to the end of ladder 2. Select the rung with the END instruction and right click (on thConnectioConnection: closen: closee rung number, not the rung) and select Import from SLC libary. Select the SLC file you just created. In my example above the data file N250 will be imprted with all the numbers in place and so will the SOR XIC S:1/15 JSR 101 EOR rung. Make sure you delete the imported rung. Viola, you have just imported a data file with numbers.
PS: Its really not a tedious as I made it sound, and once you have done it the first time, it will be a breeze to do. Play around with partial exports and imports.