import text files into databases (such as access) using visual basic???

[sena0112]

Hi, I'm a beginner in visual basic and programming. My programme needs to let the user browse for a text file and when the user press a command button, the programme will list out the text file into a datagrid.

First, I know how to import a text file into microsoft access. But that is just 1 text file. The user needs to access other text files in my programme as well.

So the problem is, using visual basic, how do I import text files into datagrid during run time?

Please guide me if anyone does know. Thank you so much!

[ansumansahu]

Hi, I'm a beginner in visual basic and programming. My programme needs to let the user browse for a text file and when the user press a command button, the programme will list out the text file into a datagrid.

First, I know how to import a text file into microsoft access. But that is just 1 text file. The user needs to access other text files in my programme as well.

So the problem is, using visual basic, how do I import text files into datagrid during run time?

Please guide me if anyone does know. Thank you so much!

Why don't you try to read the text file and put the parsed content into a temporary table. Then from that temporary table put the data into the datagrid.

-ansuman sahu

[sena0112]

Oh... So how do i put it to a temp table? Sorry I'm not very proficient in programming. Thank you.

[SanjuMtr]

Oh... So how do i put it to a temp table? Sorry I'm not very proficient in programming. Thank you.

See My Posting