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.Ole Db

Dim cn As New OleDbConnection

cn.ConnectionSt ring = "Provider=Micro soft.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.ExecuteNonQ uery()

cn.Close()

[sloan]

Re: What is SQl Command needed???

Try this link:

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

"a" <a@a.netwrote in message news:uAkNZnX8IH A.2336@TK2MSFTN GP03.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.Ole Db
>
Dim cn As New OleDbConnection
>
cn.ConnectionSt ring = "Provider=Micro soft.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.ExecuteNonQ uery()
>
cn.Close()
>
>