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

13 Mar 2006 5:37 PM

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

13 Mar 2006 6:58 PM

Homer J Simpson

"with a question" <PrashantiK***@gmail.com> wrote in message
news:1142271428.060824.54760@j33g2000cwa.googlegroups.com...

> 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.

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?

13 Mar 2006 8:16 PM

Chris

with a question wrote:

> 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
>

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

13 Mar 2006 11:49 PM

Rick Mogstad

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

Show quoteHide quote

"with a question" <PrashantiK***@gmail.com> wrote in message
news:1142271428.060824.54760@j33g2000cwa.googlegroups.com...
> 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
>

15 May 2006 12:19 PM

mumpitz

Hi,

> i have to lad each .csv in 1 temp table and then compare those 2 temp
> tables.
> any ideas ?

try 'csvdiff' (http://csvdiff.sourceforge.net/)
it's a perl script, but i think that's what you're looking for

Yours

Mumpitz -- mumpitz ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message2203022.html