I am trying to select certain records from one table and then place ALL the values retrieved into another table.
For example, if I retrieve all the records (Text1,Text4,Text5,Text7) for Table A. How can I save the records temporarily, so that I can close the current table and then open another table so that I can place all the data in Table B?
Hope that makes sense.
If conn.State = adStateClosed Then
conn.Open "Provider=sqloledb;Data Source=" & ConnectionIP & ",1433;Network Library=DBMSSOCN;Initial Catalog= CAPRegistration; User ID=sa;Password=xxxx"
esql = "select Text1 , Text4, Text5, Text7 From tblRegistration Where Committee = " & ravi & DataGridOrganization & ravi