将文件导入Access ... [英] Importing a file into Access...

问题描述

我正在将.csv文件导入到包含37个字段的Access中。我的问题是

，有时候最后一个字段只有列末尾的数据（当你将文件导入Access时，对于最后一个字段，它看起来像
，它只需要检查前几个''单元'是否有任何数据，如果没有，则不会导入

字段。


如果在字段顶部有数据

，我如何强制'访问导入字段？例如，我可能有1000条记录

我正在导入。如果只有最后100条记录在该

字段中有数据，那么，我丢失了数据，因为它没有导入该字段。


谢谢，

死神


***通过Developersdex发送 http://www.developersdex.com ***

不要只是参加USENET ......获得奖励！

I am importing a .csv file into Access that has 37 fields. My problem is
that sometimes the last field only has data at the end of the column (it
looks like when you import a file into Access, for the last field, it
only checks the top few ''cells'' to see if there is any data, if not, the
field is not imported).

How do I ''force'' Access to import the field, regardless if there is data
in the top of the field or not? For instance, I might have 1,000 records
that I am importing. If only the last 100 records have data in that
field, then, I lose the data because it is not importing the field.

Thanks,
Grim Reaper

*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!

推荐答案

使用导入规范。


在示例csv的最后一列中放置一个值。

手动启动导入：文件|获取外部|导入。

选择CSV文件后，单击高级按钮保存导入

规格。


当你这样做时将来导入，包括

TransferText中的导入规范，以便Access知道必须获得多少列。


-

Allen Browne - 微软MVP。西澳大利亚州珀斯。

访问用户提示 - http：// allenbrowne.com/tips.html

回复群组，而不是mvps dot org的allenbrowne。


死神 <再**** @ nospam.com>在消息中写道

新闻：3f *********************** @ news.frii.net ...

Use an import spec.

Place a value in the last column of a sample csv.
Start the import manually: File | Get External | Import.
After selecting the CSV file, click the Advanced button to save an import
spec.

When you do the import in future, include the import spec in the
TransferText so Access knows how many columns it must get.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Grim Reaper" <re****@nospam.com> wrote in message
news:3f***********************@news.frii.net...

我正在将.csv文件导入到包含37个字段的Access中。我的问题是，有时候最后一个字段只有列末尾的数据（当你将文件导入Access时，它看起来像是对于最后一个字段，它只会检查顶部几个''单元''看是否有任何数据，如果没有，
字段不导入。

我如何'强制''访问导入字段，无论是否有最高领域的数据？例如，我可能有1,000条记录
我正在导入。如果只有最后100条记录在该
字段中有数据，那么，我丢失了数据，因为它没有导入该字段。

I am importing a .csv file into Access that has 37 fields. My problem is
that sometimes the last field only has data at the end of the column (it
looks like when you import a file into Access, for the last field, it
only checks the top few ''cells'' to see if there is any data, if not, the
field is not imported).

How do I ''force'' Access to import the field, regardless if there is data
in the top of the field or not? For instance, I might have 1,000 records
that I am importing. If only the last 100 records have data in that
field, then, I lose the data because it is not importing the field.

I不太记得正确的合成器，但要确保

字段名称的最高记录复选框。选项已关闭。您可能想要创建一个

记录，该记录将首先出现在本机数据库排序中，并具有所有

fiel名称描述，以便在导入前一个文件时

说你的选项不会有那么多错误。如果您无法创建

记录，请在文本编辑器中手动创建。希望这会有所帮助。


figueroa at ync dot com

I don''t quite remember the correct syntx but make sure the check box for the
"top record for field name" option is off. You might want to create a
record that will appear first in the native db sort and that has all the
fiel name discriptions so that when you import the file with the previous
said option on you won''t have that many errors. If you cant create that
record, create it manually in a text editor. Hope this helps.

figueroa at ync dot com

Hi Allen，


当我单击高级按钮时，我得到的只是一个高级查找对话框

框。如何创建和保存导入规范？我在这里跳了

因为我听说过导入规格，但帮助文件没提到

它。


谢谢

" Allen Browne" <铝********* @ SeeSig.Invalid>在消息新闻中写道：< 3f ********************** @ freenews.iinet.net。 au> ...

Hi Allen,

When I click the Advanced button, all I get is an Advanced Find dialog
box. How does one create and save an import spec? I''m jumping in here
because I''ve heard of an Import Spec but the help file doesn''t mention
it.

Thanks
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<3f**********************@freenews.iinet.net. au>...

使用导入规范。

在示例csv的最后一列中放置一个值。
手动启动导入：获取外部|导入。
选择CSV文件后，单击高级按钮以保存导入
规格。

以后进行导入时，请在 TransferText让Access知道它必须有多少列。

-
Allen Browne - Microsoft MVP。西澳大利亚州珀斯。
访问用户提示 - http://allenbrowne.com/ tips.html
回复群组，而不是mvps dot org的allenbrowne。

死神 <再**** @ nospam.com>在消息中写道
新闻：3f *********************** @ news.frii.net ...

Use an import spec.

Place a value in the last column of a sample csv.
Start the import manually: File | Get External | Import.
After selecting the CSV file, click the Advanced button to save an import
spec.

When you do the import in future, include the import spec in the
TransferText so Access knows how many columns it must get.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Grim Reaper" <re****@nospam.com> wrote in message
news:3f***********************@news.frii.net...

我将.csv文件导入到具有37个字段的Access中。我的问题是，有时候最后一个字段只有列末尾的数据（当你将文件导入Access时，它看起来像是对于最后一个字段，它只会检查顶部几个''单元''看是否有任何数据，如果没有，
字段不导入。

我如何'强制''访问导入字段，无论是否有最高领域的数据？例如，我可能有1,000条记录
我正在导入。如果只有最后100条记录在该
字段中有数据，那么，我丢失了数据，因为它没有导入该字段。

I am importing a .csv file into Access that has 37 fields. My problem is
that sometimes the last field only has data at the end of the column (it
looks like when you import a file into Access, for the last field, it
only checks the top few ''cells'' to see if there is any data, if not, the
field is not imported).

How do I ''force'' Access to import the field, regardless if there is data
in the top of the field or not? For instance, I might have 1,000 records
that I am importing. If only the last 100 records have data in that
field, then, I lose the data because it is not importing the field.

这篇关于将文件导入Access ...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！