Simple separated sql question

[itayzoro]

How can i insert into field more then 1 data ???
If i try to use comma the data is insert into the next field and i want only feed Field1 with more then 1 record
or i cant fill with 1 sql statment and i need 1 stament for each record
i need somthing like "LineFeed" or "Enter"

Dim dbFileNew As String = "C:\Dest.mdb" 
        sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbFileNew 

    
        SQL24 = "INSERT INTO Table1 (Field1) VALUES(3)" 
        Dim Sconn As New System.Data.OleDb.OleDbConnection(sConnectionString) 
        Dim cmd24 As New System.Data.OleDb.OleDbCommand(SQL24, Sconn) 
        Dim dr24 As System.Data.OleDb.OleDbDataReader 
        Sconn.Open() 
        dr24 = cmd24.ExecuteReader() 
        dr24.Read() 
        dr24.Close() 
        Sconn.Close()

 

[cjard]

Please ask your database SQL questions in the Database section of the forms