Hi Fred,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to import file from an CSV
file to an MSDE database. If there is any misunderstanding, please feel
free to let me know.

As far as I know, the SQL DTS is the easiest way to achieve this. We can
use DTS to transfer data directly to the MSDE server if you have SQL client
installed.

However, we can also use C# code with ADO.NET to do this. Generally we can
use a DataSet as the temp table to store data in memory, and pass data to
MSDE server. Use an ODBCDataAdapter to fill data from the CSV file and
insert records with a SqlDataAdapter. Here I have written a code snippet.

DataSet ds = new DataSet();
OdbcDataAdapter oda = new OdbcDataAdapter("SELECT * FROM Table1.csv",
this.odbcConnection1);
oda.AcceptChangesDuringFill = false;  //Make sure to add this line, so that
the RowState will be marked as Added.
oda.Fill(ds, "Table1");     //Put data to a temp DataSet object.

SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM Table1",
this.sqlConnection1);
SqlCommand com = new SqlCommand("INSERT INTO Table1(Field1)
VALUES(@Field1)", this.sqlConnection1);
com.Parameters.Add("@Field1", SqlDbType.VarChar, 50, "Field1");
sda.InsertCommand = com;
sda.Update(ds.Tables["Table1"]); //Update the data to MSDE database.

HTH. If anything is unclear, please feel free to reply to the post.

Kevin Yu

you could also use the OPENROWSET function..

this SQL snippet will allow you to import the C:\Customers.csv file directly into your MSDE Databas

SELECT
INTO myImportTabl
FROM
    OPENROWSET('MSDASQL'
        'Driver={Microsoft Text Driver (*.txt; *.csv)};DEFAULTDIR=C:\;Extensions=CSV;'
        'SELECT * FROM Customers.CSV'