By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,497 Members | 2,127 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,497 IT Pros & Developers. It's quick & easy.

CSV help...big time!

P: n/a
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


Jun 2 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

MN wrote:
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?

--
Mike Brind

Jun 2 '06 #2

P: n/a
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.

Mike Brind wrote:
MN wrote:
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?

--
Mike Brind


Jun 4 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.