Filtering ODBC data

I have created an ODBC link into an SQL server using the Import External Data
function in Excel 2003. The data is coming through without any problems
except that there is too much of it. Excel has a limit of 65,000 lines and
there is around 300,000 lines of data trying to get through, and the data I
want is at the bottom.

I want to put a filter on one of the columns in the table but don't know
how. I can see the Edit Query box but i've never really used SQL before.

Can anybody help?

"Huwbert" <[email protected]> wrote in message
news:[email protected]...
> I have created an ODBC link into an SQL server using the Import External
Data
> function in Excel 2003. The data is coming through without any problems
> except that there is too much of it. Excel has a limit of 65,000 lines
and
> there is around 300,000 lines of data trying to get through, and the data
I
> want is at the bottom.
>
> I want to put a filter on one of the columns in the table but don't know
> how. I can see the Edit Query box but i've never really used SQL before.
>
> Can anybody help?

What does the query look like? The usual way to limit the nuber of records
is to use the WHERE statement.

/Fredrik

In MSquery, there is an option in the menus to add a criteria. Use that
option.

--
Regards,
Tom Ogilvy

"Huwbert" <[email protected]> wrote in message
news:[email protected]...
> I have created an ODBC link into an SQL server using the Import External
Data
> function in Excel 2003. The data is coming through without any problems
> except that there is too much of it. Excel has a limit of 65,000 lines
and
> there is around 300,000 lines of data trying to get through, and the data
I
> want is at the bottom.
>
> I want to put a filter on one of the columns in the table but don't know
> how. I can see the Edit Query box but i've never really used SQL before.
>
> Can anybody help?

You will need to tweak the SQL.

From the MS Query menu, View, Criteria.
A section should appear for you to filter the results.

This effectively generates the WHERE clause in your SQL.

So the SQL query will look something like
select client_name, client_address from client_table where client_name =
'Huwbert';

If you are feeling confident with SQL (or even if you're just curious) check
out my Query Editor Add-In - on my website.
It gives more control over these QueryTables - especially over Parameters.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Huwbert" <[email protected]> wrote in message
news:[email protected]...
>I have created an ODBC link into an SQL server using the Import External
>Data
> function in Excel 2003. The data is coming through without any problems
> except that there is too much of it. Excel has a limit of 65,000 lines
> and
> there is around 300,000 lines of data trying to get through, and the data
> I
> want is at the bottom.
>
> I want to put a filter on one of the columns in the table but don't know
> how. I can see the Edit Query box but i've never really used SQL before.
>
> Can anybody help?