更改传输电子表格的粘贴方向 [英] Changing the Paste Orientation of a Transfer Spreadsheet

问题描述

我正在复制粘贴我在网上找到的问题，同时我试图找到同一问题的答案，但是没有管理：


我有followig TransferSpreadsheet语句，它将查询结果移动到Excel工作簿，工作正常。问题是查询中有很多字段，人们很难阅读这些字段。有没有办法修改它，以便它垂直导出数据说a1：b无论是什么而不是a1：EN2

一个粘贴特殊转置的排序。


谢谢！


这是代码：

< span class =codeLinkonclick =Blur（this，this.parentNode.parentNode，getChildren（this），true）;>展开 | 选择 | Wrap | 行号

解决方案

好的，没有人理解这个问题或没有答案（更有可能）。我希望有一些其他解决方案可以完成这项工作。


好​​的，只是为了确定，我会试着更清楚：


是否可以在Access中编写代码来执行查询，将其导出到Excel，打开Excel文件，然后使用转置选项执行复制/剪切和粘贴？

确定。我找到了解决方案，我想分享它以防万一有人遇到同样的问题：

展开 | < span class =codeLinkonclick =selectAll（this）;>选择 | Wrap | 行号

doma23，好心情


i会尝试...


谢谢..


（ Medo ）

Hi, I''m copy pasting the question that I''ve found on the net while I was trying to find the answer on the same problem, but didn''t manage:

I have the followig TransferSpreadsheet Statement that moves the results of a query to an Excel Workbook which works fine. Problem is there are a lot of fields in the query and it is diffficult for people to read that far across. Is there a way to modify this so that it exports the data vertically say a1:b whatever instead of a1: EN2
Sort of a Paste Special transpose.

Thanks!

Here is the code:

Expand|Select|Wrap|Line Numbers

解决方案

Ok, either nobody understand the question or there is no answer (more likely). I was hoping that there are some other solutions that may do the job.

Ok, just to be sure, I''ll try to be more clear:

Is it possible to write code in Access that will
execute the query, export it to Excel, open the Excel file, then perform a copy/cut and paste with the transpose option?

OK. I have found the solution and I would like to share it just in case somebody runs on the same problem:

Expand|Select|Wrap|Line Numbers

doma23, Good soulotion

i will try it...

Thank You..

(Medo)

这篇关于更改传输电子表格的粘贴方向的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！