read csv file

Results 1 to 2 of 2

Thread: read csv file

  1. #1
    Join Date
    Dec 1969

    Default read csv file

    how can i read the csv file and display on the asp page<BR>how can i cope with the field which contain ,<BR>example as below:<BR><BR>WINE BAR MENU,,<BR><BR>Homemade fresh soup of the week,,8.5<BR>Hot smoked salmon,,17.5<BR>"Beef with chilli, guacamole",,12.5<BR><BR><BR>Thx<BR>

  2. #2
    Join Date
    Dec 1969

    Default Treat it as a database...

    Open it as a text database and the JET driver *can* automatically figure out that fields in quotes aren&#039;t split on the commas.<BR><BR>If you create a SystemDSN for it, you can specify all those kinds of characteristics (e.g., comma as delimiter; "..." as field marks, etc.).<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