How to do Edit Query from Import External Data.
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
|