how to load a .csv file to a temporary table in sql 2000

  • Thread starter Thread starter with a question
  • Start date Start date
W

with a question

hi,
i have a vb.net application.
Here is what i have to do.
i have 2 .csv files with almost similar data
i have to lad each .csv in 1 temp table and then compare those 2 temp
tables.
any ideas ?
Thanks
 
i have a vb.net application.
Here is what i have to do.
i have 2 .csv files with almost similar data
i have to lad each .csv in 1 temp table and then compare those 2 temp
tables.
Click to expand...

What would make the two different? What would not? What if there is an extra
space at the end of one field? What do you want to happen if they are
different?
 
with said:
hi,
i have a vb.net application.
Here is what i have to do.
i have 2 .csv files with almost similar data
i have to lad each .csv in 1 temp table and then compare those 2 temp
tables.
any ideas ?
Thanks
Click to expand...
Why do you need to read them into a table to compare them? Why not just
compare the two file directly?

Open each file
Read them in byte by byte or line by line and compare the two

Chris
 
Why do you need to put them into SQL tables? Using a DataTable should be
sufficient if you just need to check the values?
 
Back
Top