How can I do a notebook query like I can in Quattro

[Guest]

I'm trying to convert quattro pro files into excel files. In quattro pro I
can build a database just by making a table, then using the "notebook query"
button. Is there a similar way to do the same thing in excel?

 

[Ken Wright]

Believe you can save as a .wk4 file and then open directly in Excel

 

[Guest]

What function within excel is the same as the "notebook query" function that
is in quattro?

 

[Ken Wright]

Sorry my reply was to the text

I'm trying to convert quattro pro files into excel files.

For that kind of functionality you really need to look at either Pivot
Tables or the D functions, eg DSUM etc.