CSV help...big time!

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • MN
    #1

    CSV help...big time!

    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




    Tags: None
    • Mike Brind
      #2
      Re: CSV help...big time!


      MN wrote:[color=blue]
      > 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[/color]

      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

        Comment

        • vicky
          #3
          Re: CSV help...big time!

          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:[color=blue]
          > MN wrote:[color=green]
          > > 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[/color]
          >
          > 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[/color]

            Comment

            Previous template Next
            Working...