Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query of External Data | Excel Discussion (Misc queries) | |||
saving wkbk minus MS Query links | Excel Discussion (Misc queries) | |||
Pivot Tables referring to external data query | Excel Discussion (Misc queries) | |||
New web query with Excel Pro Edition 2003 | Links and Linking in Excel | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |