how to read multple csv file from a folder in vb.net

Question

1.00/5 (1 vote)

See more:

i want to read multiple csv files from a folder with different names and these csv's are inside different folders inside that folder. i want to search thesse csv's in different folders of that folders. so plz help me to read the csv from different folder inside that folder. tnx in advance.

Posted 9-Mar-12 1:08am

taher ahmed choudhury

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dylan Morley · Answer 1 · 2012-03-09T01:44:00

Solution 1

Have a look at the DirectoryInfo class in the System.IO namespace, C# code but simple to convert!

C#

string directoryPath = @"C:\FolderToSearch";
DirectoryInfo dir = new DirectoryInfo(directoryPath);
FileInfo[] files = dir.GetFiles("*.csv", SearchOption.AllDirectories);

foreach (FileInfo file in files)
{
    // However you want to process the CSV file
}

Posted 9-Mar-12 1:44am

Dylan Morley

Comments

Maciej Los 9-Mar-12 11:04am

My 5 despite of an example in C# ;)

taher ahmed choudhury 11-Mar-12 0:13am

after putting these code in vb.net it is not showing any csv file in thatt folder
Dim directoryPath As String = Application.StartupPath + "\Input\"
Dim dir As New DirectoryInfo(directoryPath)
Dim files As FileInfo() = dir.GetFiles("*.csv", SearchOption.AllDirectories)

' However you want to process the CSV file
For Each file As FileInfo In files
Next

plz help these are my code

Maciej Los · Answer 2 · 2012-03-09T05:01:00

Solution 2

Take a look at: DirectoryInfo.GetFiles method[^] - with an example in VB.NET.

Posted 9-Mar-12 5:01am

Maciej Los

Comments

ProEnggSoft 9-Mar-12 11:40am

Good pointer. My 5

Maciej Los 9-Mar-12 13:11pm

Thank you ;)