Re: $$Excel-Macros$$ External Query not brining in all data

2013-09-20 Thread Richard Mogy
Sorry. I was saying that the field I'm selecting in my query, called xyz is defined in the SQL table as varchar (max), which means, to me, that the number of characters cab vary to the maximum allowed by SQL. Rich On Sep 19, 2013 10:21 PM, Anoop K Sharma aks.sharm...@gmail.com wrote: Hi

Re: $$Excel-Macros$$ External Query not brining in all data

2013-09-20 Thread Anoop K Sharma
Please share your file.. On Fri, Sep 20, 2013 at 5:50 PM, Richard Mogy rm...@sbcglobal.net wrote: Sorry. I was saying that the field I'm selecting in my query, called xyz is defined in the SQL table as varchar (max), which means, to me, that the number of characters cab vary to the maximum

$$Excel-Macros$$ External Query not brining in all data

2013-09-19 Thread Richard
I have created an MS Query using our SQL database. One of the fields, which is a varchar(max) field, will not pull over. Any suggestions would be greatly appreciated. Thanks in Advance. Rich -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW)

Re: $$Excel-Macros$$ External Query not brining in all data

2013-09-19 Thread Anoop K Sharma
Hi Richard, Your query is not clear enough. Varchar is a reserved word for sql. are you using max function for getting maximum value of a column? If possible, please share your file.. Regards, Anoop Sr. Developer On Thu, Sep 19, 2013 at 9:42 PM, Richard richard.m...@gmail.com wrote: I have