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