[AccessD] Pasting into Excel

David McAfee davidmcafee at gmail.com
Thu Aug 21 12:17:57 CDT 2014


I know this question should really go to Excel-L rather than Access-D, but
you're all a smart bunch so I figured I'd ask here first. ;)


A pet peeve of mine is pasting data from and Access Query or SQL Server
Management Studio into Excel and the data is wrapped and dates always show
up weird.

I don't remember this occurring before Office 2007 (but I can't remember
past last weekend much less 7 years ago).

So every time I paste a big grid of data, I have to toggle "wrap text"
three times.

If I choose "Short Date" from the formatting drop down in the number
toolbar (in the ribbon) the dates will change to short dates.

If I past the same (or different) data from the clip board it reverts back,
losing the short data and non wrapped text formatting.

Am I silly to think it didn't work this way in earlier versions?

Thanks,
David


More information about the AccessD mailing list