[AccessD] Pasting into Excel

I think the wrap has always occurred in every version, and is not due to
encountering a new line character- that is why removing line wrap
straightens it out. Probably it is something kind of natural reaction excel
has to table-type pastable data. In the query panel there are cells but
when copying only a limited amount (and some is transcribed) of the
formatting meta data is brought over. My thinking was (and one time) this
was some kind of delimiter, acting like the import of a csv, you know,
interpreting query grid walls like commas... but I don't think that's true
any more...

May be a good reason to use automation and via to save on repeated manual
effort.
On Aug 21, 2014 2:11 PM, "James Button" <jamesbutton at blueyonder.co.uk>
wrote:

> Consider that Paste includes some (not all) of the formatting - either
> actual as
> in where Excel recognises dates (well, thinks? It has).
> There is paste Special values that will not (well probably not) change the
> formatting of cells.
>
> Re dates - you will need to consider the data being posted (as in what is
> its
> format)
> The country code of the OS, the country code of Excel, the defaults set,
> and
> what format is specified for the cells getting the data.
>
> AFAIK Excel  sets Wrap if it finds a newline in the text string
>
> Now you mention Excel 2007, but do not explicitly state what version you
> are
> using, or what OS, which could also have some effect on the clipboard
> handling.
>
> Re your question:
> No! It's MS software!
>
> JimB
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
> Sent: Thursday, August 21, 2014 6:18 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Pasting into Excel
>
> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>