自定义分割符号

Question

sql = "select * into table from [my.txt] in ""c:\\data\\"" ""text;HDR=Yes;FMT=Delimited(,) """ 这里FMT=Delimited(,) 设置自定义分割符号为逗号，为什么运行不成功

Answer 1

請參考一下，預設好像是逗號!
Connection strings for Textfile

HOW TO: Use Jet OLE DB Provider 4.0 to Connect to ISAM Databases

 

---

亂馬客blog: http://www.dotblogs.com.tw/rainmaker/

Answer 2

你好，按如下例子修改下系统设置后试试：

http://www.howtogeek.com/howto/21456/export-or-save-excel-files-with-pipe-or-other-delimiters-instead-of-commas/

 

---

Mike Feng
MSDN Community Support | Feedback to us
Please remember to mark the replies as answers if they help and unmark them if they provide no help.