Re: Update fields in previous row from fields in current row

Tony Girgenti wrote:
Hello Graham.

I'd like to try to explain what i want to do using the data at the end of this post.

The data is in a csv file and imported into a recordset. I don't have any need to update the data source or sort any data. It is simply read into the recordset. There is no query in the sense that i'm extracting a set of records from the source. I'm using all the records in the ascii, text, csv file.

<snip>

AHA!!. We wuz waylaid!!. I automatically assumed you were using an access or other dbms.

This is a lot different.
Yep, and harder to look at.

We'll have a look at the data, and get back to you. My XYL wants me off this computer.

Maybe Ralph (or any of the others) could take a look, as I mightn't get back to this until Sunday (I'm security guarding at several sites, for the next 48 hours, here in Adelaide)

Graham


Thanks,
Tony
<snip>


.

Relevant Pages

  • Re: Update fields in previous row from fields in current row
    ... I don't think i can "pull the data in one line at a time". ... The data is in a csv file and imported into a recordset. ... in the first UDT. ...
    (microsoft.public.vb.database.ado)
  • Re: Data throughput
    ... The query is used to fill a CSV file that a third party ... >SQL Server MVP ... >> a recordset being returned to the application. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Import comma delimited file
    ... Excel file can be converted into) in good form just as you can to a ... The .csv file needs to be uploaded to the server. ... So I'd suggest going through this recordset one row at a time and within ... ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool... ...
    (microsoft.public.inetserver.asp.db)
  • Using Excel to import .csv file into Access table
    ... Using Excel 2003, I need to get a csv file into an Access table. ... Open table as ADO recordset ... Check size of array to confirm field count ...
    (microsoft.public.excel.programming)
  • Re: Working with recordsets
    ... AdSR wrote: ... >> for create an CSV file and the other one is to create a HTML file. ... >> and then when I pass it to the second funtion the recordset is in the ... Or, if this doesn't suit, try creating two separate cursors from the ...
    (comp.lang.python)
Loading