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

[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

[Homer J Simpson]

"with a question" <Pr***********@gmail.com> wrote in message
news:11*********************@j33g2000cwa.googlegro ups.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?

[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

[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?
"with a question" <Pr***********@gmail.com> wrote in message
news:11*********************@j33g2000cwa.googlegro ups.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

[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