ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to put a SQL query in a single Excel cell? (https://www.excelbanter.com/excel-discussion-misc-queries/48763-how-put-sql-query-single-excel-cell.html)

Kris

How to put a SQL query in a single Excel cell?
 
I'm creating a spreadsheet that lists different queries. When we list the
odd SQL query, we want to put the entire query in a single Excel cell that
can be copied and pasted in SQL Query Analyzer. Is there a way to copy and
paste the SQL query into the cell? We're finding that when pasting, Excel
breaks it up into several lines. Additionally, typing it out doesn't always
properly format the query (like when there are comments within the query)...
Is what I'm looking to do even possible?

cindee

Kris - you'll find that Excel cells only hold 255 characters which seems like
a lot until you're copying text into them. I don't think that's going to be
a good way to list your queries. You should try Word which will maintain
your spacing and generallly look better.

"Kris" wrote:

I'm creating a spreadsheet that lists different queries. When we list the
odd SQL query, we want to put the entire query in a single Excel cell that
can be copied and pasted in SQL Query Analyzer. Is there a way to copy and
paste the SQL query into the cell? We're finding that when pasting, Excel
breaks it up into several lines. Additionally, typing it out doesn't always
properly format the query (like when there are comments within the query)...
Is what I'm looking to do even possible?



All times are GMT +1. The time now is 11:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com