MS Access ActiveX

[fpizzi]

How can I read column headers from an MS Access file using ActiveX?

I'm already reading content from file, now I really need to read the headers.

[DavidJCrawford]

I have something that uses LabSQL as a baseline with additonal functions to get the column names from a ADODB._Recordset activex class.

What version of Labview are you using?

David

[fpizzi]

I'm using LabVIEW8.0.

[DavidJCrawford]

OK try these and see if this helps you.

David

[fpizzi]

David,

Thanks for your help, but your code is returning me an error (code: -2146824579), and I couldn't found the reason.

I'm using the Acces._Application ActiveX class to read the containing data for a *.mdb file, like at attached VI. Is there, in this class, any way to read column headers?

[DavidJCrawford]

Ah you are using DAO and I am using LabSQL from http://jeffreytravis.com/lost/labsql.html. LabSQL uses ADO instead of DAO.

Sorry I don't have any DAO vi's apart from those in the ZIP attached which I picked up from NI website, I think.

I haven't tested them before this post but I think this will do what you want.

David

[fpizzi]

David,

Thank you very much! The last post was exactly what I need!

Regards!

[weeberp]

It DAO is very old for LabView 8.6.1

[DavidJCrawford]

Sorry, but the lowest version I have here is 8.5.1.

Perhaps someone else on the forum can help up-convert these VI's for you.

David

[RavensFan]

Saved in LV8.2