Filtering External Data
 

I am working with some external data in excel (from DBF File). I have
succeeded in getting the data in Excel.

I have a field /column containing invoice nos. (EXP_NO) and I have to
exclude all records from my list in which the invoice nos. begin with
LRE or SRE e.g. to include L014/05-06 but to exclude LRE02/05-06

Following is the Query that I have in Excel. (Menu DATA-Import
External Data-Edit Query

CONNECTION:
Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data
Source=G:\Seepz\TOTEXP\;Mode=Share Deny Write;Extended
Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry
Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=18;Jet
OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet
OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet
OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet
OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without
Replica Repair=False;Jet OLEDB:SFP=False

Command Type:
TABLE

Command Text:
select * from EXP where co < "LT" and EXP_NO < "L127/04-05" and
EXP_NO < "L227/04-05" and EXP_NO < "L323/04-05"


I do not know how to put modify this parameter in the MSQ to filter
this external data.

Can someone please help me.

Regards
Amish