>Experts,
>
>Client wants to import customer and sales data from their online store. The download is in CSV format. The format is displayed as such:
>Sales Date
>Order Date
>Buyer User ID
>Full name
>First Name
>Last Name
>Street 1 etc etc etc
>
>HOw can I write the code to skip certain headers/data: For example i i only want to import the First Name and Last name. How do I programmatically certain colunms in the CSV? I dont want to tell the client to modify the downloaded CSV file.

Hi Jeffrey,

You can use ODBC driver {Microsoft Access Text Driver (*.txt, *.csv)} .

MartinaJ