Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy paste SQL query result to excel spreadsheet with formatting
How can I copy paste a SQL query result to an Excel spreadsheet without the
formatting of certain columns like(date, currency) getting affected? Right now, I just use the copy-paste function and then I have to individually select each date and currency column on the excel spreadhseet and change the format. It's a labour intensive process when I have more than 20 columns to format seperately and more than 100 spreadsheets. Please let me know if there's a better way to go about it. Thanks for reading! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy paste SQL query result to excel spreadsheet with formatting
Unfortunately, there is no metadata in the clipboard that Excel can use to
pre-format or otherwise adjust the format from the sheet's default. If you are using the same query again and again just with different criteria, then set your formatting the way you want it after copying the first result set. Now make a copy of that sheet and delete the data only. Make as many copies of this new sheet as you need. When you copy in each result set the pre-existing format should be retained "Juliet" wrote: How can I copy paste a SQL query result to an Excel spreadsheet without the formatting of certain columns like(date, currency) getting affected? Right now, I just use the copy-paste function and then I have to individually select each date and currency column on the excel spreadhseet and change the format. It's a labour intensive process when I have more than 20 columns to format seperately and more than 100 spreadsheets. Please let me know if there's a better way to go about it. Thanks for reading! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can you copy and paste row height formatting in excel | Excel Discussion (Misc queries) | |||
Query, copy & paste | Excel Discussion (Misc queries) | |||
copy and paste excel spreadsheet into autocad | Excel Discussion (Misc queries) | |||
Copy Paste of Formula Produces Incorrect Result | Excel Discussion (Misc queries) | |||
How to preserve conditional formatting on a web query table result | Excel Discussion (Misc queries) |