Plotting Graph

[pkumar]

Hi,

In My Application the test results are logged into the MS Access Data Base.At Present I copy the Data to Excel and the plot the graph.This is done manually.I would like to automate this.

Is there any function in CVI which can get the data from MS Access and plot the graph.I am using the CVI version 6.2.

If this cannot be done from MS Access, is it possible to do it from MS Excel.The Application can be modified to dump the data into the Excel??

Regards
Praveen

[Ted F.]

Hi Praveen,
There's a few things you can do. The first and easiest thing is to use CVI's Database Connectivity Toolkit or SQL Toolkit. These need to be purchased seperately, but they are very powerful and easy to use.
If you don't want to take that option, you can always create a set of activeX functions to interface with MS-Access or Excel. You'll need to use the ActiveX Control Wizard in CVI to create this set of functions, but the methods exposed by Access and/or Excel should be sufficient for what you want to do. Good luck with your application Praveen.
Thanks.

[pkumar]

Hi Ted,
Thanks for the Answer.I do have the SQL Toolkit with CVI.I access the database using the ODBC drivers provided by the National Instruments SQL toolkit, version 2.0

Can you please tell me how can I use the SQL for plotting the data which has been logged into MS Access.


Regards
Praveen

[Ted F.]

Hi Praveen,
You can try for example using the DBFetchxxx functions to grab the data from the database. Once you have the data stored in a CVI datastructure (ie array, etc...), you can use CVI to plot it onto a graph. I believe you'll need to do it this way. Good luck!
Thanks,
Ted