close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()