• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Connection properties in excel

K

KiKi

Member
Is there any limit on number of rows in connection properties of excel. I am trying to paste a sql query in command text, but it's truncating the query.
 
Might be different from one version to another.

If SQL statement is too long, create a view in database and rewrite query as needed (it will be much shorter).
 
I have afile qith sql query with 48776 characters
Click to expand...

As @Chihiro has pointed out you are over the string limit, way over, your sql query with 48776 characters does seem long, can you not use defined functions?
 
bobhc said:
As @Chihiro has pointed out you are over the string limit, way over, your sql query with 48776 characters does seem long, can you not use defined functions?
Click to expand...
It's kind of package with lots of temporary tables and variables.. view willnot allow me to do so.
 
You must log in or register to reply here.
Back
Top