PDA

View Full Version : limit records in import/linked data



Kicker
08-09-2010, 04:42 PM
Without using Access, I have need to either link or import data from an external data source such as Oracle and "filter" the data to a specific value in a specific field. The Oracle tables have over 600,000 records and I only want to link/import around 200 of them. A big import would be 2,500 records (Well within the limits of earlier versions of Excel).

I can get ALL of the data, but how do I filter it? Is there a SQL statement or something?

ttfn
Kicker