select data from table and insert into another table

Hello!
Chathurika Palliyaguruge

The correct syntax of command is

INSERT INTO table2
(column_name(s))
SELECT column_name(s)
FROM table1;


In your query i find that you are missing  a  parenthesis near table name . Please remove this mistake
after that  If  it is throwing  error then please check sequence of column name in both table in your query if both table's column are not in same sequence then it will generate error

INSERT INTO Temp (Off_No,Name,Rank,SumOfWine,SumOfS/Drink,Total)
SELECT Off_No,Name,Rank,SumOfWine,SumOfS/Drink,Total From Report WHERE Off_No='" + TextBox.Text + "'

working fine for me

hi jitendra,
i try your code
showing this error
Syntax error in INSERT INTO statement

what is temp table structure

No value given for one or more required parameters

what error you are getting

Hello Chathurika,

Try this query :

"INSERT INTO Temp (Off_No,Name,Rank,SumOfWine,SumOfS/Drink,Total)
SELECT Off_No,Name,Rank,SumOfWine,SumOfS/Drink,Total From Report WHERE Off_No=''" + TextBox.Text + "''"

this also not working

query is fine

try another like

select Off_No,Name,Rank,SumOfWine,SumOfS/Drink,Total into

Temp from Report WHERE Off_No='" + TextBox1.Text + "'

i want to insert only select record

code:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
  Try

  con = New OleDbConnection(cs)
  con.Open()
  Dim cq As String = ("INSERT INTO Temp (Off_No,Name,Rank,SumOfWine,SumOfS/Drink,Total) SELECT Off_No,Name,Rank,SumOfWine,SumOfS/Drink,Total From Report WHERE Off_No='" + TextBox1.Text + "'")
  cmd = New OleDbCommand(cq)
  cmd.Connection = con
  cmd.ExecuteNonQuery()
  con.Close()
  con = New OleDbConnection(cs)


  Catch ex As Exception
  MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
  End Try

  End Sub


ReportOff_NoDateNameRankSumOfWineSumOfS/DrinkTotal

it37136	12/1/2014	KS Kumara	PO	1900	2000	3900
xp12021	12/1/2014	IPS NISANTH	PO	21	26	47
wvs76621	1/20/2015 2:44:35 PM	CMT Palliyaguruge	OD	100	78	178
898	1/1/2015	kn	n	2	3	5

share your sql query or both tables structure

Now receiving this error:
Syntax error in INSERT INTO statement

code is not visible properly

try like

INSERT INTO tblnew
(column_name(s))
SELECT column_name(s)
FROM tblold;