I have tried adding as much text as I can to the SQL pane in MS Query
and it went up to 29,996 characters. I do not think that your query is
that complex (9 A4 pages!). I'm using Excel 2003 SP2. Have you tried
it one another machine. Maybe there's something wrong with the Office
installation.
Jonathan
Bobby B wrote:
I am working in EXCEL 2003, to access external data through MS Query. I am
writing code in the SQL query edit pane,. My query and case statements are
large. The SQL query edit pane will not accept additional test. Is there a
limit to the number of characters / size for an SQL query in MS Query? If
so, can it be adjusted to accomodate additional text?
Re: Using part of a field ... See the article "Finding and replacing characters using wildcards" at: ... AS400 SQL may have a different way of doing ... called i.dsn, containing the followiing text: ... sort of thing in a query.... (microsoft.public.word.mailmerge.fields)
Re: DBMS and lisp, etc. ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database.... (eq (order-customer orderA) ... (comp.lang.lisp)
Re: mailmerge and sql ... I don't know what limit MS Query imposes but the ... If you're starting from SQL... I saw that there> was a secondary argument I could use to> get an additional 255 characters - for a whopping total of> 510 characters! ... That would be great except that my sql statement> is approximately 600 characters give or take. ... (microsoft.public.word.mailmerge.fields)
Re: Syntax error in FROM clause ... > following syntax by using the design grid and typing into the SQL... FROM clause) does not appear to be closed, that is, there is a starting "[", ... I too would not use special characters on a Column-name alias (or spaces ...query against your will. ... (microsoft.public.access.queries)
Re: Populating a list -- table structure? ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ...KitID, long integer ... (microsoft.public.access.forms)
