Select INTO statement in SQL
This article based on the SELECT INTO Statement. The SELECT INTO statement is most often used to create backup copies of tables or for archiving records.
The text of this article is not in this database — only its details are. The old site it was published on is gone, but the Internet Archive kept a copy: Select INTO statement in SQL
2 Comments
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment
It is the same account you read, post and publish with — and you will come straight back to this page.
Giovanni Rodrig Garcia RadaPosted Jul 1, 2011, 12:24 PM
Dear Praveen. I am using c# code. trying to transfer all registers from a table to another in different db. First I used INSERT INTO IN, but without success. Then seeing your post I tried with SELECT INTO, I used your format: SELECT Persons.* INTO Persons IN ' Backup.mdb ' FROM Persons But the problem is that de db has password. I tried the next line: string ComandoConsultatablaexterna = "SELECT regpbioquim.* INTO regpbioquim IN 'C:\\registrostotales.mdb';PWD=hhem53pv FROM regpbioquim"; The error message is: Characters found after end of SQL statement. Please. Help me!!!
jmayerPosted Dec 6, 2007, 9:25 AM
I am trying to take fields from two sql tables ad put them into 1 access table. The example code for the join is straight forward, but I think my issu lies in setting up the connections to the two data sources. What is the cleanest way to do this. Thanks