Select INTO statement in SQL
The text of this article is not in this database — only its details are. Read it on the old site: Select INTO statement in SQL
2 Comments
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment.
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