![]() |
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? |
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