| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel VBA & ODBC Data Sources | Excel Programming | |||
| Data import odbc | Excel Programming | |||
| Get SQL data to Excel without ODBC | Excel Programming | |||
| Working with ODBC and filtering data | Excel Programming | |||
| Importing ODBC Data .. anywhere?? | Excel Programming | |||
Threaded Mode
