CSV help...big time!

[MN]

Hello all -

I'm hoping someone out there can help me as I'm in a bind. Long and short,
I'm trying to read a flat CSV file containing 3800 rows approximately. I'm
willing to accept that doing some DB manipulation, it could be taking long
because of that but is there a better way or better yet a faster method in
ASP to read quickly through these files. It's 5 minutes or so to process 50
lines into the database. I'm currently a stream to open the text file.

Any help is greatly appreciated.
Mark

 

[Mike Brind]

Hello all -

I'm hoping someone out there can help me as I'm in a bind. Long and short,
I'm trying to read a flat CSV file containing 3800 rows approximately. I'm
willing to accept that doing some DB manipulation, it could be taking long
because of that but is there a better way or better yet a faster method in
ASP to read quickly through these files. It's 5 minutes or so to process 50
lines into the database. I'm currently a stream to open the text file.

Any help is greatly appreciated.
Mark

What is the code you are using at the moment? Which database are you
using? What do you mean by "read" the file? Are you trying to create
a report on its contents? Store it in a db? Display it on screen?
Something else?

 

[vicky]

What r u actually trying to do. Reading csv file and storing the
records in a db.

or

reading a csv file and displaying on a page.