Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Get External Data in Excel MattsConfused Excel Discussion (Misc queries) 0 December 17th 05 05:37 PM
Import External Data Jeff Excel Worksheet Functions 0 May 3rd 05 10:28 PM
Get External Data Web Query new worksheet Nina Excel Discussion (Misc queries) 0 April 14th 05 07:08 PM
Glue/Lock cells to external data before refresh Jo Betty Smith Excel Discussion (Misc queries) 0 February 16th 05 11:55 PM
How do I create a list in excel that contains external data? bill@bb Excel Discussion (Misc queries) 1 February 15th 05 02:45 AM


All times are GMT +1. The time now is 09:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"