insert data from text file to a database table

[bro4]

how can i transfer a specific text file data to a table in a database in labview....

for example this is a specific line of text file... i want each value to be inserted in a table of a database... means changing the text file record to database record..

abcxxx123;  name:john  adress:abc123  phn-no:123123

[smercurio_fc]

A response was already provided to you when you first asked this question: http://forums.ni.com/t5/LabVIEW/reading-data-from-text-file-and-saving-it-in-a-database-table/m-p/18... and again (http://forums.ni.com/t5/LabVIEW/reading-data-from-text-file-and-saving-it-in-a-database-table/m-p/18... and again (http://forums.ni.com/t5/LabVIEW/how-to-read-write-from-Access-database/m-p/1818275#M624324).

Have you researched the answer? Or do you think that asking the same question over and over again will magically provide a different answer?

[bro4]

read all my questions..all of them are different..if you can not give me answer...let others reply... what i asked in this post is totally different...

[Yamaeda]

Use the database tool Import from text file, no LV needed.

/Y

[bro4]

can you show me by an example if possible....

[smercurio_fc]

---

@bro4 wrote:

read all my questions..all of them are different..if you can not give me answer...let others reply... what i asked in this post is totally different...

---

They are all the same question, asked in different ways. That does not make them different questions. You want to update a database with some information. The information you provided is the same exact one in each of your questions. Originally you were reading this from a file. The source is irrelevant. If you want to use LabVIEW to talk to a database, you've been given the answer. If you have control of the database then you can use the database server's own tools to import data, as suggested by Yamaeda. Your call.

[Yamaeda]

http://msdn.microsoft.com/en-us/library/hh212942(v=SQL.110).aspx

/Y

[smercurio_fc]

---

@bro4 wrote:

can you show me by an example if possible....

---

Look at your database server's documentation. If you're going to use the database server to do this, then this is no longer a LabVIEW question.