越来越擅长访问....而且输入真的很愚蠢 [英] more and more excel to access....and the inputs are really stupid

问题描述

我们在excel中完成了越来越多的数据，然后他们希望将其导入

进入访问权限。

数据只是愚蠢....值为1到5我们得到很多0'好吧

好​​吧但是1-jan？

我们得到的格式为数字的字符串然后一半下来

他们被改为文字。


或者着名的好现在红色的一切都是----而且一切都是蓝色的

是 - --------。 WTF是这些人在想什么？


我可以继续关于excel和数据收集。


但我有一个问题是否有人做过很多测试和想法，并且b $ b提出了一些关于导入的指导，这样你就可以得到你想要的数据
并重新格式化你得不到或得到的东西不正确吗？

您可以使用xml或其他东西来获取单元格的颜色和它们的其他属性，以便您可以发现行中所做的更改

会导致错误吗？

仅仅是为了解释我在行和列上找到了颜色定义但是

没有关于单个单元格格式的信息。


感谢大家帮忙，想法，网页或书籍处理

这种类型的东西

Jerry

解决方案

创建导入规范 - 然后Access不会尝试猜测什么

你导入的数据类型。

Arno R花了一年半的时间来设计系统！他动辄用专家咨询
。命名为B. Quintal。 专家一直告诉他

一次一个字段导出他的数据（数十万条记录）。

它的工作原理是这样做的正确方法专家一直坚持。在每一个

转向Arno R问道，WTF现在Bob？

sparks < JS ****** @ swbell.net>在消息中写道

news：7l ******************************** @ 4ax.com ...

我们在excel中完成了越来越多的数据，然后他们希望将其导入
进入访问权限。
数据只是愚蠢....值为1到5我们得到很多0'没关系
好吧但1-jan？
我们得到的格式为数字的字符串，然后一半下来
它们被更改为文本。

或者着名的好吧现在红色的一切都是----而蓝色的一切都是---------。 WTF是这些人在想什么？

我可以继续关于excel和数据收集。

但我有一个问题，有人做了很多测试和思考，
提出了一些导入指南，这样你就可以获得你想要的数据并重新格式化你没有得到或得到的错误？
你能用xml或其他东西来获取颜色吗？细胞和它们的其他属性，以便您可以发现导致错误的行所做的更改？
只是为了exapmle我发现行和列上的颜色定义但是
没有关于单个单元格格式化。

感谢大量时间寻求帮助，想法，网页或书籍处理这类事物

Jerry

这样一个雄辩的说法，但这个问题有什么关系？


John ... Visio MVP


" PC D" < FA *** @ email.com>在消息中写道

新闻：Wf ***************** @ newsread3.news.atl.earthl ink.net ...

Arno R花了一年半的时间设计系统!!他在每一个转弯时都咨询过专家。命名为B. Quintal。 专家一直告诉他
一次一个字段地输出他的数据（成千上万的记录）。
它的工作原理是这样做的正确方法。专家一直坚持。在每一轮Arno R问道，WTF现在Bob？

blockquote>

We get more and more data done in excel and then they want it imported
into access.
The data is just stupid....values of 1 to 5 we get a lot of 0''s ok
that alright but 1-jan ?
we get colums that are formatted for number and then half way down
they are changed to text.

OR the famous ok now everything in red is ---- and everything in blue
is---------. WTF are these people thinking?

I could go on and on about excel and data collection.

but I have a question has anyone done a lot of testing and thought and
come up with some guidelines on importing so that you do get the data
you want and reformat what you don''t get or get incorrectly?
Can you use xml or something to get the colors of cells and their
other attributes so that you can spot the changes made in rows that
cause errors?
Just for exapmle I found the color definitions on rows and colums but
nothing about individual cell formatting.

thanks big time for help, ideas, web pages or books that deal with
this type of thing
Jerry

解决方案

create import specifications - then Access won''t try to "guess" what
datatypes you''re importing.

Arno R spent a year and a half designing the system!! At every turn he
consulted with an "expert" named B. Quintal. The "expert" kept telling him
to export his data (hundreds of thousands of records) one field at a time.
"It works so it is correct way to do it" the expert kept insisting. At every
turn Arno R asked, "WTF now Bob?"
"sparks" <js******@swbell.net> wrote in message
news:7l********************************@4ax.com...

We get more and more data done in excel and then they want it imported
into access.
The data is just stupid....values of 1 to 5 we get a lot of 0''s ok
that alright but 1-jan ?
we get colums that are formatted for number and then half way down
they are changed to text.

OR the famous ok now everything in red is ---- and everything in blue
is---------. WTF are these people thinking?

I could go on and on about excel and data collection.

but I have a question has anyone done a lot of testing and thought and
come up with some guidelines on importing so that you do get the data
you want and reformat what you don''t get or get incorrectly?
Can you use xml or something to get the colors of cells and their
other attributes so that you can spot the changes made in rows that
cause errors?
Just for exapmle I found the color definitions on rows and colums but
nothing about individual cell formatting.

thanks big time for help, ideas, web pages or books that deal with
this type of thing
Jerry

Such an eloquent put down, but what has it to do with the question?

John... Visio MVP

"PC D" <fa***@email.com> wrote in message
news:Wf*****************@newsread3.news.atl.earthl ink.net...

Arno R spent a year and a half designing the system!! At every turn he
consulted with an "expert" named B. Quintal. The "expert" kept telling him
to export his data (hundreds of thousands of records) one field at a time.
"It works so it is correct way to do it" the expert kept insisting. At
every turn Arno R asked, "WTF now Bob?"

这篇关于越来越擅长访问....而且输入真的很愚蠢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！