transferring a lot of data from Access Database to Labview

[RobertW]

I need to transfer 500000 -> 1000000 values in a Access database table to Labview. The values are selected using a query which is very fast if run in Access itself, but from Labview it's very slow. Obviously the connection between Labview and Access is the slow point.

Im using the NI Database connectivity toolset and a UDL file defines the connection. Microsoft Jet 4.0 OLE DB Provider is used.
To be honest i dont know what that really means, just that it normally works but now its stupidly slow for so much data.

Thanks for any help.

Rob

[Underflow]

One of my continual gripes with the DBCT is it's poor behavior on large data sets. See NI's response here:

http://digital.ni.com/public.nsf/3efedde4322fef19862567740067f3cc/862567530005f0a186256a33006b917a?OpenDocument

Actually, I wouldn't find it nearly so annoying but for the part that says "In most database books you are told not to return large recordsets...". I prefer the freedom to make a mess of things myself, thanks.

On the plus side, the VI referenced in the article is fairly efficient, you just have to deal with type conversion once things have been moved into LabVIEW.