s****u
发帖数: 23 | 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********o
发帖数: 2565 | 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**t
发帖数: 2744 | 3 define import spec
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
|
f********t
发帖数: 74 | 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. |
