需要将我的excel导入从垂直切换到水平 [英] Need to switch my excel import from vertical to horizontal

问题描述

嘿，我正在使用excel表，该表直接显示产品信息，并在第一列中显示信息标题。我试图将其导入Access，它只允许我选择标题标题的第一行。有没有办法
make是这样我可以为我的标题标题选择我的第一列？我无法复制excel中的数据并粘贴翻译，因为整个过程中的随机公式未正确锁定。任何想法？

解决方案

安德鲁，

听起来你正在使用向导进行导入过程。如果是这样，它以某种方式工作并期望某些事物作为输入。如果您当前的设置无法与向导一起使用，则可能必须使用VBA创建自己的导入/导出过程。

只需我2美分......

Hey, I am using an excel table that shows product information vertically with the information titles in the first column. I am trying to import this into Access and It is only allowing me to select the first row for my title headings. Is there a way to make is so that I can select my first column for my title headings? I cannot copy the data in excel and paste the translation because the there are random formulas throughout that are not locked correctly. Any ideas?

解决方案

Hi Andrew,

Sounds like you're using the Wizard for the import process. If so, it works a certain way and expect certain things as input. If your current setup does not work well with the Wizard, you might have to create your own import/export process using VBA.

Just my 2 cents...

这篇关于需要将我的excel导入从垂直切换到水平的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！