Access是假的，还是我？ [英] Is Access bogus, or is it me?
问题描述
我有一个工作是通过点击界面自动导入Excel数据并发布到数据库表，
。选择文件和它休息的那种
的东西。
Cient将数据存储在他的工作表中的列中（我告诉他们应该是一排，
但这是另一个问题）。有时，工作表会添加新列。那时
，访问/导入规范不会识别新列。
DoCmd.TransferText acImportDelim，importSpec，TABLE_NAME ;，SHEET NAME，
True
*无法存储Excel文件的链接并使用它，因为工作表有
Access中识别为日期的列中的文本数据，并显示#Num和
在尝试查询/发布数据时出现数字溢出错误。
*不能将工作表保存为.csv并导入它，或者存储到.csv的链接，
因为某些数据在名称周围有引号，所以它会被拆分
错了。另外，当用户向工作表添加列并保存为.csv时，
Access不会看到新列，因为导入规范不会识别
他们。
*不能将表格保存为.txt（制表符分隔）并导入，或存储链接到
.txt，因为当用户向工作表添加列并保存为.txt时，
Access不会看到新列，因为导入规范不会识别
他们。
我无法弄清楚如何做到这一点 - 事实上我认为不可能做到这一点。
或我错过了什么吗？
I have a job to automatically import Excel data and post to database tables,
via a point-click interface. Choose-file-and-it-does-the-rest kind of
thing.
Cient stores data in columns in his sheet (I told them it should be in rows,
but that''s another issue). Sometimes the sheet gets new columns added. At
that point, Access/import spec won''t recognize the new columns.
DoCmd.TransferText acImportDelim, "importSpec", "TABLE_NAME", "SHEET NAME",
True
* can''t store a link to the Excel file and use it, because the sheet has
text data in columns which Access recognizes as dates, and it shows #Num and
gives Numeric Overflow errors when trying to query/post the data.
* can''t save sheet as .csv and import it, or store a link to the .csv,
because some of the data has quotes around names, and it gets split up
wrong. Plus, when the user adds columns to the sheet and saves as .csv,
Access won''t see the new columns because the import spec won''t recognize
them.
* can''t save sheet as .txt (tab-delimited) and import it, or store a link to
the .txt, because when the user adds columns to the sheet and saves as .txt,
Access won''t see the new columns because the import spec won''t recognize
them.
I can''t figure out how to do this - in fact I think it can''t be done.
Or am I missing something?
推荐答案
我怀疑它既不是。
为什么他们会添加新列（！），这对我来说听起来很愚蠢。
我希望表模式保持不变但数据要改变
（根据你的意见，我认为你也这样做），如果有正当理由为什么
他们是dding列而不是行然后我可以看到有一个理由要求b $ b追求这个，如果他们应该添加行而不是列然后告诉他们
这就是他们所拥有的要做并停止让自己生活困难。
-
Terry Kreft
" DFS" < nospam@dfs_.com写在消息中
新闻：Ks ****************** @ bignews1.bellsouth.net ..
I suspect it''s neither.
Why would they be adding new columns (!), that sounds very stupid to me.
I would expect the table schema to stay the same but the data to change
(from your comments I think you do as well), if there is a valid reason why
they are adding columns instead of rows then I can see there is a reason to
pursue this, if they should be adding rows instead of columns then tell them
that is what they have to do and stop making life difficult for yourself.
--
Terry Kreft
"DFS" <nospam@dfs_.comwrote in message
news:Ks******************@bignews1.bellsouth.net.. .
我有工作自动导入Excel数据并发布到数据库
I have a job to automatically import Excel data and post to database
表，
tables,
通过点击式界面。选择文件和它休息的那种
的东西。
Cient将数据存储在他的工作表中的列中（我告诉他们应该是
via a point-click interface. Choose-file-and-it-does-the-rest kind of
thing.
Cient stores data in columns in his sheet (I told them it should be in
行，
rows,
但这是另一个问题。有时，工作表会添加新列。
but that''s another issue). Sometimes the sheet gets new columns added.
At
这一点，访问/导入规范不会识别新列。
DoCmd.TransferText acImportDelim，importSpec，TABLE_NAME，SHEET
that point, Access/import spec won''t recognize the new columns.
DoCmd.TransferText acImportDelim, "importSpec", "TABLE_NAME", "SHEET
NAME"，
NAME",
True
*无法存储Excel文件的链接并使用它，因为工作表有
列中的文本数据，Access将其识别为日期，并显示#Num
True
* can''t store a link to the Excel file and use it, because the sheet has
text data in columns which Access recognizes as dates, and it shows #Num
和
and
在尝试查询/发布数据时出现数字溢出错误。
*无法将工作表保存为.csv并导入，或存储指向.csv的链接，
，因为有些数据引用了名称，并且它被分开了
错误。另外，当用户向工作表添加列并保存为.csv时，
Access不会看到新列，因为导入规范不会识别
他们。
*不能将表格保存为.txt（制表符分隔）并导入，或存储链接
gives Numeric Overflow errors when trying to query/post the data.
* can''t save sheet as .csv and import it, or store a link to the .csv,
because some of the data has quotes around names, and it gets split up
wrong. Plus, when the user adds columns to the sheet and saves as .csv,
Access won''t see the new columns because the import spec won''t recognize
them.
* can''t save sheet as .txt (tab-delimited) and import it, or store a link
到
to
.txt，因为当用户向表格添加列并保存为
the .txt, because when the user adds columns to the sheet and saves as
..txt，
..txt,
Access不会看到新列，因为导入规范不会识别
他们。
我无法弄清楚如何做到这一点 - 事实上我认为不可能做到。
或者我我错过了什么？
Access won''t see the new columns because the import spec won''t recognize
them.
I can''t figure out how to do this - in fact I think it can''t be done.
Or am I missing something?
Terry Kreft写道：
Terry Kreft wrote:
我怀疑它不是。
I suspect it''s neither.
如果Access为开发人员提供方法和属性
以编程方式更新导入/导出规范，那将是很好的。
It would be nice if Access provided methods and properties for the developer
to update the import/export specs programmatically.
为什么他们会添加新列（！），这听起来非常愚蠢到
我。
Why would they be adding new columns (!), that sounds very stupid to
me.
这就是他们的家伙如何使用他的电子表格。他有名单和
职称名单。他在添加职称时添加了专栏（尽管它很少是b
）。我告诉他这不是那种方式，但他有一堆查询
和其他进程违背他的表格。
That''s how their guy works with his spreadsheets. He has lists of names and
job titles. He adds columns when he adds job titles (though it is
infrequent). I told him it wasn''t the way, but he has a bunch of queries
and other processes going against his sheet.
我希望表格架构保持不变，但是数据会改变（从您的评论中我认为你也会这样做），如果有一个
有效的理由为什么他们正在添加列而不是行然后我可以
看到有理由追求这个，
I would expect the table schema to stay the same but the data to
change (from your comments I think you do as well), if there is a
valid reason why they are adding columns instead of rows then I can
see there is a reason to pursue this,
没有真正有效的理由使用列，但有许多有效
的原因不是。
There is no truly valid reason to use columns, but there are many valid
reasons not to.
如果他们应该添加行
而不是列，然后告诉他们这是他们必须做的事情和
停止让自己生活困难。
if they should be adding rows
instead of columns then tell them that is what they have to do and
stop making life difficult for yourself.
ha！那是我今天早上得到的感觉。
我不善于告诉客户'你必须这样做''。我更喜欢
来解决他们的情况。但是，如果这需要一个完全自动化的系统，那么这个可能不会成立。
谢谢
" DFS" < nospam@dfs_.com写在消息中
新闻：Ks ****************** @ bignews1.bellsouth.net ..
"DFS" <nospam@dfs_.comwrote in message
news:Ks******************@bignews1.bellsouth.net.. .
>我有一个工作，通过点击界面自动导入Excel数据并发布到数据库
表。
选择 - 文件和它做的事情。
Cient将数据存储在他的工作表中的列中（我告诉他们应该在行中的数据，但是那是'另一个问题）。有时候工作表会添加新的
列。
>I have a job to automatically import Excel data and post to database
tables, via a point-click interface.
Choose-file-and-it-does-the-rest kind of thing.
Cient stores data in columns in his sheet (I told them it should be
in rows, but that''s another issue). Sometimes the sheet gets new
columns added.
At
>那一点，访问/导入规范不会识别新列。
DoCmd.TransferText acImportDelim，importSpec，TABLE_NAME，SHEET
NAME，True
*无法存储链接到Excel文件并使用它，因为工作表
包含Access中识别为日期的列中的文本数据，并且在尝试查询/时显示#Num并显示数字溢出错误发布数据。
*不能将表格保存为.csv并导入它，或存储指向
.csv的链接，因为有些数据引用了名称，并且它得分错了。另外，当用户在工作表中添加列并将其保存为.csv时，Access不会看到新列，因为导入
规范不会识别它们。
*不能将工作表保存为.txt（制表符分隔）并导入它，或存储
链接到.txt，因为当用户向工作表添加列时
并保存为.txt，Access不会看到新的列，因为
导入规范不会识别它们。
我无法弄清楚如何做到这一点 - 事实上我认为不可能做到。
或者我错过了什么？
>that point, Access/import spec won''t recognize the new columns.
DoCmd.TransferText acImportDelim, "importSpec", "TABLE_NAME", "SHEET
NAME", True
* can''t store a link to the Excel file and use it, because the sheet
has text data in columns which Access recognizes as dates, and it
shows #Num and gives Numeric Overflow errors when trying to
query/post the data.
* can''t save sheet as .csv and import it, or store a link to the
.csv, because some of the data has quotes around names, and it gets
split up wrong. Plus, when the user adds columns to the sheet and
saves as .csv, Access won''t see the new columns because the import
spec won''t recognize them.
* can''t save sheet as .txt (tab-delimited) and import it, or store a
link to the .txt, because when the user adds columns to the sheet
and saves as .txt, Access won''t see the new columns because the
import spec won''t recognize them.
I can''t figure out how to do this - in fact I think it can''t be done.
Or am I missing something?
U R teh SUCK。嘿。
O.K.，认真的。为什么不编写转换电子表格的代码，
从而将列转换成行？然后以数据库
存储数据的方式存储数据，并让jagoff保持他的数据，就像jagoff
意图保留数据一样。每个人都很开心。
我很胜!!
DFS写道：
U R teh SUCK. heh.
O.K., seriously. Why not write code that transposes the spreadsheet,
thus turning columns into rows? Then store the data the way a database
is meant to store it, and let the jagoff keep his data the way a jagoff
was meant to keep it. Everyone''s happy.
I am teh WIN!!
DFS wrote:
我有一个工作来自动导入Excel数据并发布到数据库表，
通过点击式界面。选择文件和它休息的那种
的东西。
Cient将数据存储在他的工作表中的列中（我告诉他们应该是一排，
但这是另一个问题）。有时，工作表会添加新列。那时
，访问/导入规范不会识别新列。
DoCmd.TransferText acImportDelim，importSpec，TABLE_NAME ;，SHEET NAME，
True
*无法存储Excel文件的链接并使用它，因为工作表有
列中的文本数据，Access将其识别为日期，并显示#Num和
在尝试查询/发布数据时出现数字溢出错误。
*不能将表格保存为.csv并导入它，或者存储到.csv的链接，
因为某些数据引用了名称，所以它得到了分手
错了。另外，当用户向工作表添加列并保存为.csv时，
Access不会看到新列，因为导入规范不会识别
他们。
*不能将表格保存为.txt（制表符分隔）并导入，或存储链接到
.txt，因为当用户向工作表添加列并保存为.txt时，
Access不会看到新列，因为导入规范不会识别
他们。
我无法弄清楚如何做到这一点 - 事实上我认为不可能做到这一点。
或我错过了什么吗？
I have a job to automatically import Excel data and post to database tables,
via a point-click interface. Choose-file-and-it-does-the-rest kind of
thing.
Cient stores data in columns in his sheet (I told them it should be in rows,
but that''s another issue). Sometimes the sheet gets new columns added. At
that point, Access/import spec won''t recognize the new columns.
DoCmd.TransferText acImportDelim, "importSpec", "TABLE_NAME", "SHEET NAME",
True
* can''t store a link to the Excel file and use it, because the sheet has
text data in columns which Access recognizes as dates, and it shows #Num and
gives Numeric Overflow errors when trying to query/post the data.
* can''t save sheet as .csv and import it, or store a link to the .csv,
because some of the data has quotes around names, and it gets split up
wrong. Plus, when the user adds columns to the sheet and saves as .csv,
Access won''t see the new columns because the import spec won''t recognize
them.
* can''t save sheet as .txt (tab-delimited) and import it, or store a link to
the .txt, because when the user adds columns to the sheet and saves as .txt,
Access won''t see the new columns because the import spec won''t recognize
them.
I can''t figure out how to do this - in fact I think it can''t be done.
Or am I missing something?
这篇关于Access是假的，还是我？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
