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!
|