Parser CSV file!!

Results 1 to 2 of 2

Thread: Parser CSV file!!

  1. #1
    Join Date
    Dec 1969

    Default Parser CSV file!!

    I need to read from a CSV file in the format as below, then insert data into database: <BR><BR>stockno, make, model, price, description, engine, doors <BR>name,price,description,remark<BR>apple,1.2.3," good,bad","form ""china"""<BR><BR>because of the commas and double quote between the double quotes, I can not split the text by comma.<BR><BR>Any suggestion?

  2. #2
    Join Date
    Dec 1969

    Default Hmmm...maybe don't parse?

    Treat the CSV file as a database and see if the JET engine can parse it for you???<BR><BR>The JET engine can be used to handle text databases, so I&#039;d try that first.<BR><BR><B R><BR>then scan down the page a little ways to <BR>"You can also open a Text file using the JET OLE DB Provider"<BR><BR>Be sure to follow the link to the MS knowledge base that he provides.<BR><BR>If that doesn&#039;t work, then come ask again.<BR><BR>

Posting Permissions

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