JohnyQuick Posted May 21, 2011 Posted May 21, 2011 Hi, New user here, so take pitty I need to connect to an Excel file, that gets writen to everytime a Chromatograph makes a run. We have it set up to calculate Total gas, from how much C1 to C5 is present/ So, My question is, Do I write a sequence, and then use SQL, Select command to get the Cells in excel that I need? Just How do I do this? So, far, I have-set up ODBC in Administrative Tools-Settings to find the file. I Think I write a sequence, but do I make channels, that I need from this chromatograph excell sheet? using the Select lanquage from SQL? Do I write script, like Select C12? Where C12 is the data in C12 of the ODBC that I need? But , How do I then make C12 equal to the channel # that I need to log-under logging? And where in DAQFACTORY do I do that? Expressions? This is important for me, because I need to accomplish this to get my project going,and to show to Customer that I can get this done. Or, should I go the device route, and try to connect to the Chromatograph program(That receives data and puts it into Excell with a separate program Called ****-name a secret) using the Devices-subroutine of DAQFACTORY? I need to get this online using DAQCONNECT, so he can see realtime chromatographs from the field ASAP. Also, to get my project going, I need to put time on the Y axis, and Gas value-channel on the X axis-how do I do this?
AzeoTech Posted May 22, 2011 Posted May 22, 2011 Again, are you sure you can't get that secret chomatagraph program to write to a csv or some other format than Excel?
Recommended Posts
Archived
This topic is now archived and is closed to further replies.