ask lang unsaon pagbalhin ang data sud sa txtfile didto sa table(database) using vb?

[reyarita]

---

Naamoy idea ana? Unsaon pagbalhin ang data sud sa txtfile padung didto sa table(database).

[sanggano_boy]

gamitan nimo di ai nimo ug filesystemobject object, to open and access the file, then put it on the database?

[dodie]

the only close relation to that is CSV, Comma Separated Values.
Is only an ordinary text file, with data separated by commas, delimited by quotes for each data. Next line is the new record.

If you have a program that reads CSV, then you have no problem importing it into the designated Table(database).

[salbahis]

the only close relation to that is CSV, Comma Separated Values.
Is only an ordinary text file, with data separated by commas, delimited by quotes for each data. Next line is the new record.

If you have a program that reads CSV, then you have no problem importing it into the designated Table(database).

dodie is right, if you encode it on excel then export it to a csv... there is already and existing components for that, btw what VB are you using VBA?, VB6? or .Net?

[reyarita]

VB 6 ako gigamit

[harryperales]

pwede kaayo na, just use follow the tutorial here to get the contents of the Text Files Into a Recordset then from the recordset to your database table assuming nga gamit ka ug ADO

[unretry]

I sugges do it using CSV file format, mas dali pa ma insert ang data to the db, just millisecond for how thousands of records