What is SQl Command needed???

[a]

Dear Frends I have this code but I don't know the SQL Code to copy data from
CSV file to new table in the current access data base

What is SQl Command needed???

Imports System.Data.OleDb

Dim cn As New OleDbConnection

cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=test.mdb;Persist Security Info=False"

cn.Open()

Dim cmd As New OleDbCommand

cmd.CommandText = ("I need sql Command to copy data from CSV to New table in
the current data base ")

cmd.Connection = cn

cmd.ExecuteNonQuery()

cn.Close()

 

[sloan]

Try this link:

http://www.siccolo.com/Articles/Cod...s-development-tips-1.html#DataSetfromTextFile