Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get External Data in Excel | Excel Discussion (Misc queries) | |||
Import External Data | Excel Worksheet Functions | |||
Get External Data Web Query new worksheet | Excel Discussion (Misc queries) | |||
Glue/Lock cells to external data before refresh | Excel Discussion (Misc queries) | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) |