March 21, 2003 at 11:26 am
I have an application called RSLinx that uses a PLC to capture data off of a packaging machine. This application uses DDE's (Dynamic Data Exchange), I can get the data into an Excel spread sheet but would like to stream the data into a table but not sure where to start. I am greener than green right now on this topic so bear with me.....
Steve Johnson
Steve Johnson
March 21, 2003 at 1:46 pm
You can use DTS on some schedule to load the data. Not sure you can get any better "streaming" than this.
Steve Jones
March 22, 2003 at 2:18 am
Out on a limb here, but I think you could create a VB app that 'talks' DDE and then inserts the data into a table in SQL Server. Or just a VBA function in your Excel sheet?
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
March 24, 2003 at 8:02 am
I suspected that I would need to us VB or JAVA to pull the data in but wasn't sure....
Steve Johnson
Steve Johnson
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply