need code for reading from a text file and inserting values in databas

[AAli]

hi
m aali
i want a programm which can take values from a text file and can insert values in the database
if some one have code for this programm in visual basic plz let me know

thanking

 

[MikeLacey]

Hi Ali,

This doesn't sound too difficult....

The problem is in three parts though:

1) Reading the text file

2) Formatting the data from the text file

3) Inserting data into a database.

So let's take it a step at a time; what's the format of your text file and we'll talk about reading data from it and splitting it into some variables. [sig]<p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>Making mistakes, so you don't have to. &lt;grin&gt;[/sig]

 

[AAli]

thx for helping mike

i did it in ASP but i want to make it in visual basic
i dont know more abt VB so plz if u can help me in this

 

[MikeLacey]

Where are you having troubls Aali? [sig]<p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>Making mistakes, so you don't have to. &lt;grin&gt;[/sig]

 

[AAli]

not in ASP's
but i dont have any idea for VisalBasic

can u plz send me a test programm in which i can look the codes for reading a text file n inserting the values in the database using ODBC + ADO

thx for helping me again
i mailed u at ur email did u receive ?
my email add is akhtaryab@hotmail.com

i will wait ur reply
thxx again

 

[TRYP]

once you have set up the database connection and defined your record set use the &quot;execute&quot; command using an SQL INSERT statement [sig][/sig]