open .csv file

[Carlomagno]

I need to incorporate some emails that are in a csv file, all sorted in one column, into a mySQL database.

I dont find the way to open the CSV file in ADO, and dont know how lines are managed in a CSV. ¿can someone write down the sintax for me?

[MikeParent]

I believe this will work:

Copy the file locally to your computer
Create an ODBC DSN to the csv file (using the data source manager in Program -> Admin Tools)
Create an ODBC DSN to your MySQL Server
Use Microsoft DTS (included in the MSDE download (http://www.microsoft.com/sql/msde/downloads/download.asp))to import the data from csv to MYSQL