Advertisement

11.12.2007 at 09:05AM PST, ID: 22954971
[x]
Attachment Details

Import .csv file to datatable, compare to a 2nd datatable...VS2005/VB.NET

Asked by webkiwi1 in Microsoft Visual Basic.Net, .NET

Tags: csv, import, datatable, file

Hello Experts!

I need code to:
Import a .csv file (comma delimited) into a data table with 2 columns
(note. the second column value is irrelevant at this time)

Then:
I will be reading each row from a 2nd datatable and IF the first column of 2nd table is equal to any value in any of the rows in the 1st column of the 1st datatable...do something.

I have the 2nd table in place already, and the do something is also there...just need to connect the final pieces.

Thanks.
MichaelStart Free Trial
 
Keywords: Import .csv file to datatable, compar…
Title
1 import csv file to a dataTable
2 Exporting a DataTable to a CSV file
3 txt to csv
4 CSV to DATATABLE
5 Importing a CSV file into SQL Server.
6 Exporting Data into CSV/Excel
 
Loading Advertisement...
 
[+][-]11.12.2007 at 09:42AM PST, ID: 20265714

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Visual Basic.Net, .NET
Tags: csv, import, datatable, file
Sign Up Now!
Solution Provided By: VBRocks
Participating Experts: 1
Solution Grade: A
 
 
[+][-]12.15.2007 at 03:15AM PST, ID: 20476962

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628