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=quot;quot;;User ID=Admin;Data
Source=G:\Seepz\TOTEXP\;Mode=Share Deny Write;Extended
Properties=quot;quot;;Jet OLEDB:System database=quot;quot;;Jet OLEDB:Registry
Path=quot;quot;;Jet OLEDBatabase Password=quot;quot;;Jet OLEDB:Engine Type=18;Jet
OLEDBatabase Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet
OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password=quot;quot;;Jet
OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet
OLEDBon'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;gt; quot;LTquot; and EXP_NO lt;gt; quot;L127/04-05quot; and
EXP_NO lt;gt; quot;L227/04-05quot; and EXP_NO lt;gt; quot;L323/04-05quot;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
- Jun 22 Fri 2007 20:38
Filtering External Data
close
全站熱搜
留言列表
發表留言