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

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?

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"raflknr" wrote in message
...
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?

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

"Ken Wright" wrote:

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"raflknr" wrote in message
...
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?

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"raflknr" wrote in message
...
What function within excel is the same as the "notebook query" function
that
is in quattro?

"Ken Wright" wrote:

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)

--------------------------------------------------------------------------
--

"raflknr" wrote in message
...
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?