Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel Database Query String Too Long
Hi!
I am trying to update a workbook (2002, 2003 versions) to remove many of the values from an Access database query. The database is old and contains many old records, so I am trying to make the workbooks a little faster by not updating those records. The problem is I can not get all the excludes in the field before it runs out of characters. Is there a better way to exclude records? Here is the SQL query: <'BLH ~ Blakeney Heath' And <'BRK ~ Brookmere' And <'LDP ~ Lake Davidson Park' And <'MDW ~ Meadowmont at Highland Creek' And <'WGR ~ Withers Grove' And <'WGV ~ Withers Grove V' And <'GLB ~ Glyndebourne' I need to add several more and will be adding as the years progress. I am working on getting them to "archive" older projects, so we don't have to exclude so many. Any help would be appreciated! Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative path in database query connection string | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Excel Database Query String Too Long | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |