MS Access question? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

MS Access question?

MS Access question?# Database - 数据库

s*u2007-05-24 07:05

1 楼

I want to import a text file with millions of SSN to Access but every SSN in
text files have quotation marks. How can I get rid of quotation marks so
that in Access database, it just show the 9 digits.
Thanks

y*o2007-05-24 07:05

2 楼

Use sed.
Or if you are on Windows, use notepad or MS Word's find and replace all.

in

【在 s****u 的大作中提到】

: I want to import a text file with millions of SSN to Access but every SSN in
: text files have quotation marks. How can I get rid of quotation marks so
: that in Access database, it just show the 9 digits.
: Thanks

c*t2007-05-24 07:05

3 楼

define import spec

in

【在 s****u 的大作中提到】

f*t2007-05-24 07:05

4 楼

During the import process, access will ask you what kind of delimiter is used in the
import file. In the same page, you can specify the double quote as field specifier (as long as in the double quote, it is one value even though there is delimiters in it). it will solve the problem.