LabView to Access

[JFMoynihan]

I would like to use LabView to write a text file (generated in LabView) to
Microsoft Access. I thought there was a VI to aid in this, but I have been
unable to find it. Can anyone help?
Thanks.

[Jared 323]

John,

There are several VI's for reading and writing text files under functions>>File
IO. There is also an SQL toolkit which contains VI's to read and write (among
others) to database files (which are not text files). This is an add-on
that you can buy from NI. Maybe i'm not understanding your question fully.
What exactly are you trying to do?

Jared

"John Moynihan" wrote:
>>I would like to use LabView to write a text file (generated in LabView)
to>Microsoft Access. I thought there was a VI to aid in this, but I have
been>unable to find it. Can anyone help?>Thanks.

[Wilbur S.]

If you have the SQL Toolkit, you can find examples of writing data to MS Access by going to the Developer Zone and going to Resource Library >> LabVIEW >> Toolkits >> SQL.

Another path you may want to consider exploring is using ActiveX to pass data to MS Access. This may be tricky to implement if you are not familiar with ActiveX and how MS Access exposes its ActiveX properties. You might want to see how ActiveX communication is established by looking at some examples of ActiveX with other Microsoft Office products by visiting the Developer Zone and going to the Resource Library >> Connectivity >> ActiveX. However, it has been with my experience that using the SQL Toolkit to be the easiest way to communicate with MS Access.

Best Regards,
Wilbur Shen

National Instruments