如何读取管道定义的文件并将数据导出到Oracle? [英] How to read pipe delimeted file and export the data to Oracle?

问题描述

我有一个平面文件，其中包含用管道分隔的信息.我需要读取文件并将数据插入Oracle.

有人可以帮我吗?

谢谢.

I have one flat file which has information delimited by pipe. I need to read the file and insert data to Oracle.

Can someone please help me?

Thanks.

推荐答案

String.Split是您最简单的选择.

VB程序集还包括TextFieldParser类:
http://msdn.microsoft.com/en-us/library/microsoft. visualbasic.fileio.textfieldparser.aspx [ ^ ]

String.Split would be your simplest option.

The VB assembly also includes the TextFieldParser class:
http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.fileio.textfieldparser.aspx[^]

我是vb.net的新手.

如果您或有人可以帮助我提供示例代码，我将不胜感激.另外，我也在寻找在Oracle数据库中插入数据的方法.

预先感谢.

I am new to vb.net.

I would really appreciate if you or someone can help me with sample code. Also, I was looking for inserting data in Oracle database.

Thanks in advance.

这篇关于如何读取管道定义的文件并将数据导出到Oracle?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！