Import TAB delimited text file into SQL 2005

[shil]

Hi,

I'm trying to find a right way the data from a TAB delimited UTF-8
text file into SQL database. My text file has Unicode characters like
ö, é. I'm trying to code this in vb.net. Can any one guide me in the
right direction?

Thanks.

[Henning Krause [MVP - Exchange]]

Hello,

you should open the file with a StreamReader and pass the
Encoding.UTF8Encoding encoding to the constructor:

Dim instance As New StreamReader(path, encoding)

You can then read through the file with the instance.ReadLine() method.

Best regards,
Henning Krause
"shil" <jo******@gmail.comwrote in message
news:11**********************@e1g2000hsg.googlegro ups.com...
Hi,

I'm trying to find a right way the data from a TAB delimited UTF-8
text file into SQL database. My text file has Unicode characters like
ö, é. I'm trying to code this in vb.net. Can any one guide me in the
right direction?

Thanks.

[Paul Clement]

On 15 Mar 2007 14:27:27 -0700, "shil" <jo******@gmail.comwrote:

¤ Hi,
¤
¤ I'm trying to find a right way the data from a TAB delimited UTF-8
¤ text file into SQL database. My text file has Unicode characters like
¤ ö, é. I'm trying to code this in vb.net. Can any one guide me in the
¤ right direction?

There are several possibilities here. Have you tried using the SQLBulkCopy class or the Transact SQL
Bulk Insert statement?
Paul
~~~~
Microsoft MVP (Visual Basic)

[Rad [Visual C# MVP]]

On 15 Mar 2007 14:27:27 -0700, shil wrote:

Hi,

I'm trying to find a right way the data from a TAB delimited UTF-8
text file into SQL database. My text file has Unicode characters like
ö, é. I'm trying to code this in vb.net. Can any one guide me in the
right direction?

Thanks.

If you have very large text files you might also want to investigate SQL
server's bulk insert statement
--
Bits.Bytes
http://bytes.thinkersroom.com