How do you output an array using one VI to a microsoft access file and then access it using a separate VI

[dave2]

Hi,
Im relatively new to this whole labview style of programming and I need to take and have one VI output an array to a microsoft access file and then have a separate VI be able to read that access file. Im using LV 6.1, so if anyone has any ideas they would be greatly appreciated.

David

[Dennis_Knutson]

To make it easy, you should get the Database Connectivity Toolkit. If you're familiar with SQL, there is also the LabSQL Toolkit. ActiveX can be used as well but that's slower and a lot more complicated.

[dave2]

Thanks a lot for responding. Ill look into it. But for the sake of being cheap, like I am, is there a way to do it using what I've got. It does not have to be Access, it can be anything. But if possible I would prefer to put it into Access.

David

[Photon_Dan]

LabSQL is free. That's pretty cheap.

Dan Press
PrimeTest

[Dennis_Knutson]

In the interest of being cheap, then use LabSQL. It's free. As I said, you can use Access's ActiveX functions to write and read. There is also the shipping examples to read and write. These use DDE which is even worse than ActiveX. Both the Database Connectivity Toolkit and LabSQL are based on ADO. With either, you can write/read to any database. If and when Access is not suitable any more, the upgrade to a real database is easy.

[dave2]

Thank you both very much for you help, it was extremely needed. I will give SQL a try and see what I come up with.

David