Re: Excel Database Query String Too Long

From: Karl Burrows (karlspam_at_spam.yourbeacon.com)
Date: 01/27/05 

Date: Thu, 27 Jan 2005 01:25:45 -0500

Yes, at some point, that would be a good idea!

"keepITcool" <xrrcvgpbby@puryyb.ay> wrote in message
news:xn0dxpn05d0rfhr001keepitcoolnl@msnews.microsoft.com...

wouldn't it be easier to either:
either add a boolean field to the DB named : Archived? or somthing.

or create a table of Ärchived Projects and then create an query like
SELECT Customers.*
FROM Customers LEFT JOIN Archived ON
Customers.CompanyName = Archived.CompanyName
WHERE Archived.CompanyName Is Null;

... that would make maintenance a whole lot easier than
changing your queries all the time... 

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam
Karl Burrows wrote :
> 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!

Relevant Pages

  • Re: Excel Database Query String Too Long
    ... either add a boolean field to the DB named: ... > I am trying to update a workbook to remove many> of the values from an Access database query. ... > I am working on getting them to "archive" older projects, so we don't> have to exclude so many. ...
    (microsoft.public.excel)
  • Re: Excel Database Query String Too Long
    ... either add a boolean field to the DB named: ... or create a table of Ärchived Projects and then create an query like ... > I am trying to update a workbook to remove many> of the values from an Access database query. ... > I am working on getting them to "archive" older projects, so we don't> have to exclude so many. ...
    (microsoft.public.excel.programming)
  • Re: Excel Database Query String Too Long
    ... either add a boolean field to the DB named: ... > I am trying to update a workbook to remove many> of the values from an Access database query. ... > I am working on getting them to "archive" older projects, so we don't> have to exclude so many. ...
    (microsoft.public.excel.programming)
  • Re: Excel Database Query String Too Long
    ... either add a boolean field to the DB named: ... or create a table of Ärchived Projects and then create an query like ... > I am trying to update a workbook to remove many> of the values from an Access database query. ... > I am working on getting them to "archive" older projects, so we don't> have to exclude so many. ...
    (microsoft.public.excel.misc)
  • Re: Excel Database Query String Too Long
    ... either add a boolean field to the DB named: ... or create a table of Ärchived Projects and then create an query like ... > I am trying to update a workbook to remove many> of the values from an Access database query. ... > I am working on getting them to "archive" older projects, so we don't> have to exclude so many. ...
    (microsoft.public.excel)