Read from a textfile and save in database

[Brian Henry]

fix your date then maybe someone will help you first..

 

[zPaul]

The logic is you read a line and chop it out according to the position of
each type of data. For LDCustomer, you will get substring of 0 to 4 etc..

 

[Gilad Goldberg]

I would use StringReader to read the line, not substring. Cleaner, i
believe.

The logic is you read a line and chop it out according to the position of
each type of data. For LDCustomer, you will get substring of 0 to 4 etc..

 

[Lasse Edsvik]

are you using access or sql server?

if sql server you can do a bulk insert with bcp

/Lasse

 

[[ F e r n a n d o L o p e s ]]

Sorry about the date man.
I change to test some functions in one program and forgot.

 

[[ F e r n a n d o L o p e s ]]

Well, ok but, how can I do the loop.
I need help to write the logical code for get the data from de .txt file and
insert into the database
Is something like this?

StreamReader file = new StreamReader("C:\\data.txt");
for (int i=0;i<file.Lenght;i++)
{
Here i don´t know what am i do!!
}

Thanks.

Fernando Lopes

The logic is you read a line and chop it out according to the position of
each type of data. For LDCustomer, you will get substring of 0 to 4 etc..

 

[[ F e r n a n d o L o p e s ]]

Hello Lasse.
Sorry but, what is a bulk insert with bcp?

Thanks

Fernando Lopes