Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
raflknr
 
Posts: n/a
Default 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   Report Post  
Ken Wright
 
Posts: n/a
Default

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   Report Post  
raflknr
 
Posts: n/a
Default

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   Report Post  
Ken Wright
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Query of External Data Excel GuRu Excel Discussion (Misc queries) 2 January 3rd 05 07:43 PM
saving wkbk minus MS Query links Bill_S Excel Discussion (Misc queries) 1 January 3rd 05 06:00 PM
Pivot Tables referring to external data query Excel GuRu Excel Discussion (Misc queries) 4 December 29th 04 06:29 PM
New web query with Excel Pro Edition 2003 Chandler Links and Linking in Excel 2 December 15th 04 06:03 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM


All times are GMT +1. The time now is 06:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"