如何从文本文件导入unicode数据将UTF-8格式保存到MDB中的表中 [英] How to import unicode data from a text file saves as UTF-8 format into a table in MDB
问题描述
大家好,
我们一直在使用'select * into' 到目前为止,语句将数据从文本文件(用逗号分隔)导入到MDB表中,如下所示。
We have been using 'select * into' statement so far to import data from a text file (delimeted by comma) into an MDB table as follows.
SELECT * INTO< table name> FROM< textfile name> IN'''文本;数据库=<文本文件的路径> ;; FMT =分隔; HDR =是'
SELECT * INTO <table name> FROM <textfile name> IN '' 'text;database=<path of the text file>;FMT=Delimited;HDR=Yes'
例如SELECT * INTO MyReport FROM [L0_100155891.TXT] IN' ''text; database = C:\Temp \CC-842823851-1001558910015588 \; FMT =分隔; HDR =是'
for example SELECT * INTO MyReport FROM [L0_100155891.TXT] IN '' 'text;database=C:\Temp\CC-842823851-1001558910015588\;FMT=Delimited;HDR=Yes'
现在我们有一个文本文件保存在utf- 8格式,有一些utf-8格式数据。但上述声明失败,并显示消息"在文本文件规范中'L0_100155891.TXT',Col9选项无效。"
Now we have a text file saved in utf-8 format which has some utf-8 format data. But the above statement fails with message "In the text file specification 'L0_100155891.TXT', the Col9 option is invalid."
任何人都可以帮助我这里缺少什么吗?
Can anyone help me what is missing here?
谢谢,
Siva。
推荐答案
此外, MDB中用于unicode数据的列的数据类型应该是什么?
Also, what should be the datatype of the column in MDB for the unicode data?
谢谢,
Siva。
这篇关于如何从文本文件导入unicode数据将UTF-8格式保存到MDB中的表中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!