Load all txt files in a folder into adatabase

[ri]

Need to be able to allow the user to choose a whole folder and load it's contents (many txt files) all at once into the database.

 

[Malaviya]

Hi

U can use the Scripting object in VB to do the file handling as well as opening them to read line by line.

The Scripting object supports all types of file handling methods. U can go through the documentation about the Scripting object in MSDN and find out a solution to your self.

 

[culshaja]

Another option is to invoke a batch file to merge all the files into one, and then open that file for loading.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[MichaelRed]

I would opt for the Dir function. Called once with the file "Pattern", then a while/Wend loop to get the remainder.

Just old fashioned, I guess.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over