What is SQl Command needed???

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
Tue Jul 29 09:14:04 CDT 2008

Try this link:

http://www.siccolo.com/Articles/CodeProject/miscellaneous-development-tips/miscellaneous-development-tips-1.html#DataSetfromTextFile






"a" <a@a.net> wrote in message news:uAkNZnX8IHA.2336@TK2MSFTNGP03.phx.gbl...
> 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()
>
>