How to read data from a zipped MS Access file?

[RPJ]

How to read data from a zipped MS Access file?

[RavensFan]

First you are going to have to unzip the file and put it somewhere.  There are some VI's that work with zip files under the file I/O palette.

Once you have that, you will need to communicate with it.  Search the forums for numerous examples on how to communicate with an Access file.

[Jon_S.]

Hello RPJ,

There is a VI located in File I/O»Zip»Unzip that will unzip a folder.  Use this and then you could either use ActiveX to communicate to Access or the Database Connectivity Toolkit.

[RPJ]

Thank you.

Do I need to use "Close Zip File.vi" after that?

[RPJ]

I do not have the Database Connectivity Toolkit.

Would you happen to have (or point me to) an example?

Thanks.

[Jon_S.]

RPJ,

You do not need to use the Close Zip File.vi when you unzip a folder.  This VI is used when you are creating a zip folder.

As for examples, I found a couple of ActiveX based MS Access examples.  These programs look to be pretty basic.  For more in depth example I would search Microsoft Developers Network

http://zone.ni.com/devzone/cda/epd/p/id/2188

http://zone.ni.com/devzone/cda/epd/p/id/1694

[Dennis_Knutson]

Using ActiveX and Access is not a very optimum solution, imho. If you don't want to buy the Database Connectivity Toolkit, try LabSQL. You will also find numerous posts on using ADO.