Re: How to do Edit Query from Import External Data.
- From: "Arvi Laanemets" <arvilaanemets@xxxxxx>
- Date: Mon, 10 Jul 2006 12:35:51 +0300
Hi
When sarting with Data>Import External Data>Edit Query, you are allowed to
set filter conditions, and sorting order.
Or, in query wizard, you can enter filter conditions and set sorting orders
in special filter/sort rows of wizard (maybe you have to say wizard to show
them before).
Or, in query wizard, you select SQL view from menu, and edit SQL-string
yourself.
Arvi Laanemets
"Excel General Questions" <Excel General
Questions@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:110EC0C2-027C-4381-9F35-EBF16E6794C0@xxxxxxxxxxxxxxxx
I'd like to import data from external excel file. I did as follows:
Data\Import External Data\Import Data
Select Data Source
Go to the path to get data
Open the file
Import data
But I'd like to make a Edit Query to sort out items I need.
For example: Sort out items with the total q'ty more than 100.
I went to Data\Import External Data\Edit Query. But I couldn't do the
Command Text.
Pls help me. Tks
Tuy Phuong
.
- Prev by Date: Building Sum by Matching String
- Next by Date: Re: If Function with Multiple Conditions
- Previous by thread: Building Sum by Matching String
- Next by thread: Need your kind and argent help
- Index(es):
Relevant Pages
|
