VB 2010 how to import txt to access

hi.
i need to import text file into access database...
i`m using oledb.
i didnt find anything on the web... in VB.NET
thanks

Quote:

---

Originally Posted by caba11

hi.
i need to import text file into access database...
i`m using oledb.
i didnt find anything on the web... in VB.NET
thanks

---

I don't think you searched at all, because there are millions of examples over the Internet.
Anyway, what particular part of the task you find difficult?
Before you begin to write any code though, I should point out that MS Access has native import functions and allows importing of txt files without any programming. Perhaps this option will suit you better.
If not, then your program should do the following:

1. Open a connection to the db
2. Open the text file for reading
3. Read a line from the file.
4. Parse and split the values if necessary.
5. Execute a query which puts the data values from step 4 into the db table
6. Repeat from step 3 until the end of the file
7. Close the file
8. Close the db connection

Now, which step of the above you need help with?

thanks for reply.
i need to do it in my program...
i gonna try it like you said....