read CSV file

[JF Bouthillier]

Hi all,

Can someone please tell me what would be the best way to
read a CSV file and perform actions according to values
within that file?

Thank you.
JF

 

[Van T. Dinh]

Since you can link a CSV file to Access as a "Linked Table", you can create
a Recordset based on the linked Table. Then you can traverse the Recordset,
retrieve the values from the current row of the Recordse and perform actions
as required.

The other way is to treat the CSV File as a Text file and you can write code
to read the Text file one line at a time and manipulate the String (one line
from the CSV file), sparate the values from the String and perform actions
as required.