300K行数据...转换 [英] 300K rows of data ...conversion
问题描述
嗨我正在使用MS Office Access 2003.任何人都知道如何将
从文本转换为300-400K行到例如号码？
我试过这几次，并且访问告诉我那里没有
足够的内存或什么的。有人知道快速修复那个
的问题吗？谢谢
hi I am using MS office Access 2003. ANybody knows how to
convert more than 300-400K rows from text into e.g. number ?
I tried to do so a few times and access told me there aint
enough memory or something. Anybody knows quick fix to that
problem ? thanks
推荐答案
el * *******@o2.pl 写道：
嗨我正在使用MS office Access 2003.任何人都知道如何
将超过300-400K的行从文本转换为例如号码？
我试过这几次，并且访问告诉我那里没有
足够的内存或什么的。有人知道快速修复那个
的问题吗？谢谢
hi I am using MS office Access 2003. ANybody knows how to
convert more than 300-400K rows from text into e.g. number ?
I tried to do so a few times and access told me there aint
enough memory or something. Anybody knows quick fix to that
problem ? thanks
-----开始PGP签名消息-----
哈希：SHA1
你必须在表中创建一个新的数据数据
类型。然后运行一个UPDATE查询，将文本值复制/转换为
数字列。
如果你得到内存不足的话。 UPDATE期间出错，可能是
，因为你的计算机中没有足够的内存（RAM），或者
访问只是变得脾气暴躁。在开发过程中，Access开始吃掉了很多内存。为避免错误，您可以尝试关闭Access&然后
重新打开它&立即运行UPDATE查询。
如果这不起作用，请尝试更新数据块而不是
整个表;使用这样的WHERE子句：
（假设您的数据涵盖5年，每年大约20,000行）
WHERE date_column BETWEEN＃1 / 1/2004＃AND＃12/31/2004＃
然后将日期范围更改为下一年&重新运行UPDATE。重复
，直到你覆盖了表格中的所有日期范围。
-
MGFoster ::: mgf00< atearthlink< ; decimal-pointnet
奥克兰，加利福尼亚州（美国）
**仅回复此新闻组。我不回复电子邮件**
----- BEGIN PGP SIGNATURE -----
版本：个人隐私5.0的PGP
Charset：noconv
iQA / AwUBRSlRxYechKqOuFEgEQLLMwCgnyo3DPx8bJccLtQdWJBn5q uKJ + kAnRO3
+ WiAU2Di5BKYlvJJkpYYd32Q
= pr95
-----结束PGP SIGNATURE -----
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
You''ll have to create a new column in the table w/ the new numeric data
type. Then run an UPDATE query that copies/converts the text value into
the numeric column.
If you get the "not enough memory" error during the UPDATE, it may be
because you really don''t have enough memory (RAM) in your computer, or
Access is just getting grumpy. During development Access starts to eat
a lot of memory; to avoid the error you could try closing Access & then
re-opening it & immediately run the UPDATE query.
If that doesn''t work, try updating chunks of the data instead of the
whole table; use WHERE clauses like this:
(say your data covers 5 years, with about 20,000 rows per year)
WHERE date_column BETWEEN #1/1/2004# AND #12/31/2004#
then change the date range to the next year & re-run the UPDATE. Repeat
until you''ve covered all the date ranges in the table.
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRSlRxYechKqOuFEgEQLLMwCgnyo3DPx8bJccLtQdWJBn5q uKJ+kAnRO3
+WiAU2Di5BKYlvJJkpYYd32Q
=pr95
-----END PGP SIGNATURE-----
On Sun，2006年10月8日19:30:11 GMT，MGFoster< me @ privacy.comwrote：
的确，或使用类似TOP 10000的东西。大多数执行方法返回
a受影响的记录数，因此您可以循环直到该数字为0.
-Tom。
<夹>
On Sun, 08 Oct 2006 19:30:11 GMT, MGFoster <me@privacy.comwrote:
Indeed, or use something like "TOP 10000". Most Execute methods return
a count of records affected, so you could loop until that number is 0.
-Tom.
<clip>
>
如果这不起作用，请尝试更新数据块而不是
整个表;使用这样的WHERE条款：
（说你的数据涵盖了5年，每年约有20,000行）
在哪里date_column BETWEEN＃1/1/2004＃AND＃12 / 31/2004＃
然后将日期范围更改为下一年&重新运行UPDATE。重复
直到你覆盖了表格中的所有日期范围。
>
If that doesn''t work, try updating chunks of the data instead of the
whole table; use WHERE clauses like this:
(say your data covers 5 years, with about 20,000 rows per year)
WHERE date_column BETWEEN #1/1/2004# AND #12/31/2004#
then change the date range to the next year & re-run the UPDATE. Repeat
until you''ve covered all the date ranges in the table.
我不确定这些家伙如何回答你的问题。他们必须阅读比你写的更多
。
忘记300,000到400,000的记录
无论你在谈论什么，并给予
就是一个明显的例子。你在尝试什么？
要做什么。你的意思是什么？
"转换...从文本到例如数字
究竟是什么？号码，嗯？
您是否正在尝试转换四个到4或
三十三到33？我不知道这些家伙正在回答什么。我确定
不能将你的问题反向工程
他们的答案。
I''m not sure how these guys answered
your question. They must-a-read a lot more
into it than you wrote.
Forget the 300,000 to 400,000 records of
whatever it is you''re talking about and give
is one clear example. What are you trying
to do. Just what is it you mean by
"convert ... from text into e.g. number"
What exactly is an "e.g. number", huh?
Are you trying to convert "four" to 4 or
"thirty-three" to 33? I don''t know what
these guys are answering. And I sure
can''t reverse-engineer your question out
of their answer.
这篇关于300K行数据...转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
