INSERT选项卡分隔文本文件以访问数据库 [英] INSERT tab delimited text file to access database

问题描述

您好我有这段代码：

Hi i have this code:

Dim query As String = "INSERT INTO  SEGDATA (School, Campus, AdminNo, ModuleCode, ModuleGrp) " & _
      "SELECT F1 as School, F2 as Campus, F3 as AdminNo, F4 as ModuleCode, F5 as ModuleGrp FROM [Text;DATABASE=" & System.IO.Path.GetDirectoryName(Me.OpenFileDialog1.FileName) & ";HDR=NO].[" & Me.OpenFileDialog1.SafeFileName & "]"

哪个可以正常插入逗号分隔文件到访问数据库，但是我想插入TAB分隔文件，我怎么编辑这个？



提前致谢！

Which it works fine inserting comma delimited file into the access database, but i wanna insert TAB delimited file, how can i edit this?

Thanks in advance!

推荐答案

我找到了这个链接。

请检查。



http://social.msdn.microsoft.com/Forums/en-US/ 9ac36a61-8556-4b50-861e-11db2d36b1d1 / how-to-import-tab-delimited-text-file-into-access-table- [ ^ ]



http://stackoverflow.com/questions/2143245/whats-the-best-way-to-read-a-tab-delimited-text -file-in-c-sharp [ ^ ]



尝试添加

Hi, I found this links.
Please check.

http://social.msdn.microsoft.com/Forums/en-US/9ac36a61-8556-4b50-861e-11db2d36b1d1/how-to-import-tab-delimited-text-file-into-access-table-[^]

http://stackoverflow.com/questions/2143245/whats-the-best-way-to-read-a-tab-delimited-text-file-in-c-sharp[^]

Try to add

FMT=TabDelimited

。

这篇关于INSERT选项卡分隔文本文件以访问数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！