Re: How to update CSV file by OleDBDataAdapter?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Val Mazur (group51a_at_hotmail.com)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 00:14:38 -0400

Hi,

you cannot open any text file in an updatable mode. This is a limitation.
You would need to find another way to do this - writing directly to the
file, but not through the Oledb Provider 

-- 
Val Mazur
Microsoft MVP
"Evgeny Zoldin" <zoldin@hotmail.com> wrote in message 
news:O%23b%23oZEdEHA.3300@TK2MSFTNGP09.phx.gbl...
> Hi ALL,
>
> there a lot of examples how to read data from CSV file, but I could not 
> find
> any about how to save changed or newly inserted data back to the file. I
> tried to call method Update on OleDbDataAdapter which filled respective
> table, but debugger jumped out of the called function back to the caller
> without any exception, while no chaged data were saved into the CSV file!
>
> Why oDataAdapter.Update( oDataTable ) does not work and is it possible to
> save changes "automatically" (not "manually" - row by row, field by
> field...)?
>
> Thanks
>
>

Relevant Pages

  • Re: What is the maximum number of columns supported by ADO
    ... I tried to read a csv file which has 320 columns, ADO only reports the first 256. ... Yes this is known limitation for MS Jet csv engine. ... Same limitation exists with MS ODBC text driver, however maybe there is some 3pds drivers out there. ...
    (borland.public.delphi.database.ado)
  • Re: Maximum Columns in Table
    ... I tried to pull it into Access, ... limitation, I can't get it all in there. ... and parse it out into a normalized tall-thin table structure. ... I'm not quite sure what you mean by "CSV file (which has columns and rows ...
    (microsoft.public.access.tablesdbdesign)
  • Re: What is the maximum number of columns supported by ADO
    ... I tried to read a csv file which has 320 columns, ADO only reports the ... Yes this is known limitation for MS Jet csv engine. ... Same limitation exists with MS ODBC text driver, ...
    (borland.public.delphi.database.ado)
  • What is the maximum number of columns supported by ADO
    ... I tried to read a csv file which has 320 columns, ADO only reports the first 256. ... Is this a known limitation? ...
    (borland.public.delphi.database.ado)