Results 1 to 4 of 4

Thread: Speed this up? (SQL & a CSV)

  1. Nov 7th, 2001, 08:48 AM #1
    Static
    Static is offline

    Thread Starter
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Speed this up? (SQL & a CSV)

    Ive got some SQL that will be dumping large amounts of data out to CSV files for excel to open

    currently I have it looping through each line and dumping it into the CSV. is there a way to get ALL the results from the SQL into one string without having to loop through?

    EX:

    SQL = "Select FName ||','|| LName from Customers"

    [open RS here]
    [Open CSV file]

    Do while No Rs.EOF
    Print #1, rs.fileds(0).value
    loop

    etc.
    etc.

    is there a command or something that has ALL the data without having to use the Do While?

    thnx
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"
    Reply With Quote Reply With Quote
  2. Nov 7th, 2001, 08:57 AM #2
    RSINGH
    RSINGH is offline
    Fanatic Member RSINGH's Avatar
    Join Date
    May 2001
    Location
    London
    Posts
    522
    Is this from Access, SQL Server or VB?
    The liver is bad. It must be punished.
    Reply With Quote Reply With Quote
  3. Nov 7th, 2001, 09:08 AM #3
    Static
    Static is offline

    Thread Starter
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390
    VB reading an Oracle DB.

    using the MDAC 2.6
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"
    Reply With Quote Reply With Quote
  4. Nov 7th, 2001, 11:04 AM #4
    Static
    Static is offline

    Thread Starter
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390
    [Bump]



    anyone?
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width