Conectar Excel a QVD

[mnobile77]

Dear good morning, I would like to know if there is a way to connect data from a QVD to an Excel?

[marcus_sommer]

No, at least not directly. More easier as looking for such an approach would be to store the qvd-data not only as qvd else also as csv which could be easily opened with Excel and/or used as an external source.

- Marcus

[rbartley]

Hi,

I think that there might be an add-in, but the simplest thing would be to include an additional store command in the app that generates your QVD and specify the format as txt, e.g:-

Store [tablename] into [lib://...../filename.csv](txt);

You can specify the delimiter by adding a second argument e.g. (txt, delimiter is '\t');

You can then use this csv file directly in Excel.

[rbartley]

Sorry  Marcus,  we must have been writing our replies at the same time.

[mnobile77]

Muchísimas gracias!!