| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a single cell be protected in Excel 2003? | Excel Worksheet Functions | |||
| Can I create an IF formula for single cell w/ dif. text in Excel? | Excel Discussion (Misc queries) | |||
| Returning data to Excel sheet from MS query | Excel Discussion (Misc queries) | |||
| how can I split a single cell diagonally in Excel 2000 | Excel Discussion (Misc queries) | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Linear Mode
