select data from table and insert into another table

Question

Pankaj Kumar Choudhary · Answer

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

Khargesh Rajput · Answer

INSERT INTO Temp (Off_NoNameRankSumOfWineSumOfS/DrinkTotal) SELECT Off_NoNameRankSumOfWineSumOfS/DrinkTotal From Report WHERE Off_No=' + TextBox.Text + ' working fine for me

Chathurika Palliyaguruge · Answer

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

Chathurika Palliyaguruge · Answer

Temp Off_No Name Rank SumOfWine SumOfS/Drink Total

Khargesh Rajput · Answer

what is temp table structure

Chathurika Palliyaguruge · Answer

No value given for one or more required parameters

Khargesh Rajput · Answer

what error you are getting

Jitendra Kumar · Answer

Hello Chathurika Try this query : INSERT INTO Temp (Off_NoNameRankSumOfWineSumOfS/DrinkTotal) SELECT Off_NoNameRankSumOfWineSumOfS/DrinkTotal From Report WHERE Off_No='' + TextBox.Text + ''

Chathurika Palliyaguruge · Answer

this also not working

Khargesh Rajput · Answer

query is fine try another like select Off_NoNameRankSumOfWineSumOfS/DrinkTotal into Temp from Report WHERE Off_No=' + TextBox1.Text + '

Chathurika Palliyaguruge · Answer

i want to insert only select record

Chathurika Palliyaguruge · Answer

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_NoNameRankSumOfWineSumOfS/DrinkTotal) SELECT Off_NoNameRankSumOfWineSumOfS/DrinkTotal 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 Report Off_No Date Name Rank SumOfWine SumOfS/Drink Total 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

Khargesh Rajput · Answer

share your sql query or both tables structure

Chathurika Palliyaguruge · Answer

Now receiving this error: Syntax error in INSERT INTO statement

Khargesh Rajput · Answer

code is not visible properly try like INSERT INTO tblnew (column_name(s)) SELECT column_name(s) FROM tblold;