473,326 Members | 2,133 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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


Jun 2 '06 #1
2 1131

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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: PHPkemon | last post by:
Hi there, A few weeks ago I made a post and got an answer which seemed very logical. Here's part of the post: PHPkemon wrote: > I think I've figured out how to do the main things like...
3
by: Jay | last post by:
I previously posted this question under Visual Basic newsgroup, but was advised to re-post here. I'm hoping someone can help me solve an issue I'm having with VB.Net and Access 2000. Here's...
3
by: FRITSCH Vincent | last post by:
Hi, i need help on a query. I've this table : create table t ( customer number(5), time date, status varchar2(1)
5
by: John Flynn | last post by:
hi all i'm going to be quick i have an assignment due which i have no idea how to do. i work full time so i dont have the time to learn it and its due date has crept up on me .. As follows:...
3
by: stuart_white_ | last post by:
I've just upgraded from Python 2.3.3 to Python 2.4.2, and, although the new version of Python seems to be running correctly, I can't seem access the help from the interpreter. On Python 2.3.3...
2
by: Prophet | last post by:
Can someone help me troubleshoot this IISSTATE log ? I have tried to make sense out of it but with no luck I am currently running IIS5 on a Win 2k box. Hosting 3 web sites and runnning asp...
6
by: Takeadoe | last post by:
Dear NG, Can someone assist me with writing the little code that is needed to run an update table query each time the database is opened? From what I've been able to glean from this group, the...
0
by: gunimpi | last post by:
http://www.vbforums.com/showthread.php?p=2745431#post2745431 ******************************************************** VB6 OR VBA & Webbrowser DOM Tiny $50 Mini Project Programmer help wanted...
6
by: priyajohal | last post by:
#include<fstream.h> #include<process.h> #include<stdlib.h> #include<conio.h> #include<string.h> #include<dos.h> #include<ctype.h> #include<stdio.h> void setup() void help();
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.