problem writing with ADO to a csv file

From: Max Odendahl (nospam_max.odendahl_at_t-online.de)
Date: 04/16/04 

Date: Fri, 16 Apr 2004 16:41:34 +0200

Hallo,

I am trying to write into a csv file.

Reading from the file works perfectly with "select" statement, but when I
try to insért a value, I get the following error:

The INSERT INTO-statement contains the following unknown fieldname....

My insert statement is: insert into [timetracker#csv]
Values('1','systeme','xyz')

Is anyone fmailiar witht his problem and knows a solutions?

Kind regards
Max

Relevant Pages

  • Re: Getting double records from .csv files
    ... Yes the path name is returing true. ... State Dhump of Himalaya ... > Where are you reading the CSV file or loading the CSV file.Is the path ... > name having the CSV file name... ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: manipulating csv file fields through perl
    ... from the spreadsheet for manipulation? ... What did reading the source tell you? ... Would $table be the name of the csv file? ...
    (perl.beginners)
  • Re: r vs rb in csv (was Re: Python SHA-1 as a method for unique file identification ? [help!])
    ... It's your script. ... Windows, the OS pretends that EOF occurs at the first instance of byte ... The string used to terminate lines in the CSV file. ... You are correct, modern software shouldn't and usually doesn't gratuitously write ^Z to files, but there is is some software out there that still does, hence the preservation of the convention on reading. ...
    (comp.lang.python)
  • Re: Read new record from CSV textfile and item not found
    ... but you have to debug to read another record? ... If you want help with reading the file, you need to post your code. ... Ts'i mahnu uterna ot twan ot geifur hingts uto. ... I made a Windowsform that reads data from a CSV file. ...
    (microsoft.public.dotnet.languages.vb)
  • Daily water meter readings
    ... Download data from a controller in to a CSV file. ... Want to subtract the first ... reading on a day from the last reading of a given day to get tptal daily ...
    (microsoft.public.excel.worksheet.functions)