Filtering ODBC data

[Guest]

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?

 

[Fredrik Wahlgren]

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

 

[Tom Ogilvy]

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

 

[Rob van Gelder]

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.