Re: What is the maximum number of columns supported by ADO


"Andre M. Descombes" <amdescombes@xxxxxxxxxxxxx> ???????/???????? ? ????????
?????????: news:45363c1b$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I tried to read a csv file which has 320 columns, ADO only reports the
first 256. Is this a known limitation?
Yes this is known limitation for MS Jet csv engine. Also be ready that even
those 256 columns could be messed up.
Is there a way to overcome it?
Same limitation exists with MS ODBC text driver, however maybe there is some
3pds drivers out there.


.

Relevant Pages

  • Re: How to update CSV file by OleDBDataAdapter?
    ... you cannot open any text file in an updatable mode. ... This is a limitation. ... > tried to call method Update on OleDbDataAdapter which filled respective ... while no chaged data were saved into the CSV file! ...
    (microsoft.public.dotnet.framework.adonet)
  • 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)
  • 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)
  • Re: ASM vs HLL : absurd war
    ... |> No limitation like this with ASM. ... From the Athlon Optimisation Guide: ... | MS didn't bother with that driver after they got it working. ... |> but my favourite are the AMDs (fast shift, fast bit, and cheaper). ...
    (alt.lang.asm)