问题描述
大家好,
我们一直在使用'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。
推荐答案
谢谢,
Siva。
这篇关于如何从文本文件导入unicode数据将UTF-8格式保存到MDB中的表中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!